Calculate Film Comfort Breaks using EARLIER
To calculate the required number of comfort breaks for each film based on its running time, by referencing a non-joined comfort breaks table using the EARLIER function to manage row context.
DAX Function
VALUES Power BI DAX exercises.
These concepts all use VALUES. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.
6Related concepts
Concepts Using VALUES
Conditional Data Omission in Matrix Visuals using CALCULATE, VALUES, and FILTER
Learn to create DAX measures that conditionally omit specific data categories (like environments) from calculations in a matrix visual, leveraging the CALCULATE, VALUES, and FILTER functions to manipulate filter context.
Creating Dynamic Labels and Tooltips with DAX Measures
Learn to create dynamic labels for card visuals and detailed tooltips for charts using various DAX functions to enhance report interactivity and user experience.
Dynamic Report Title with Slicer Selections using ISFILTERED, VALUES, and CONCATENATEX
Learn to create a dynamic measure for a report title that automatically updates based on user selections in a slicer, handling single, multiple, or no selections.
Dynamically Displaying Product Names Based on Filter Context Using VALUES and Conditional Logic
Learn to create a DAX measure that dynamically displays product names in a table, showing a single product, a list of multiple products, or a specific message for aggregated totals, leveraging the VALUES function.
Implementing Dynamic Unit Scaling for Financial Measures with Slicers
Learn to create dynamic measures that adjust their output based on a single selection in a slicer, using `HASONEVALUE` and `VALUES` to retrieve the selected unit's divisor. Also, create a conditional title based on slicer selection.