In Power BI Desktop, you want to add a numeric field that is recalculated every time a user interacts with slicers and other report filters, instead of being stored in the model when data is loaded. Which data modeling feature should you use?
Measure
Table relationship
Report-level filter
Calculated column
A measure is defined with DAX and is evaluated dynamically at query time, so its value changes whenever the report's filter context changes (for example, when users move slicers). Calculated columns are computed once during data refresh and their results are stored in the model. Table relationships connect tables but do not create new computed fields, and report-level filters simply restrict data shown in visuals without creating any new field.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.