Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
HI @umanbr ,
Hierarchy field not support to create based on measures. BTW, measure also not able to use as category.
If you mean use one measure to display multiple measure result, this is possible. You can use switch function to check current category, then use category value to return correspond measure surely.
DAX – Making the “Case” for SWITCH()
Regards,
Xiaoxin Sheng
HI @umanbr ,
Hierarchy field not support to create based on measures. BTW, measure also not able to use as category.
If you mean use one measure to display multiple measure result, this is possible. You can use switch function to check current category, then use category value to return correspond measure surely.
DAX – Making the “Case” for SWITCH()
Regards,
Xiaoxin Sheng
HI @umanbr ,
You can try to create a what if parameter table, then you can use selected value and current category to choose which measure to displayed:
Create and use a What if parameter to visualize variables in Power BI Desktop
Regards,
Xiaoxin Sheng
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |