DAXDAX Trainer

DAX Function

HASONEVALUE Power BI DAX exercises.

These concepts all use HASONEVALUE. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.

View all DAX functions

2Related concepts

Concepts Using HASONEVALUE

IntermediateVALUESHASONEVALUECONCATENATEXISFILTERED

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.

Open
IntermediateHASONEVALUEVALUESDIVIDEIFBLANK

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.

Open