Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
Can any one help me out, how can I create a level based measures in Power BI Desktop.
User will select a detail level column value will come from drill through filter. I have to show detail level count for that selected value and also show the count for other levels.
Quick response would be really appreciable.
Thanks,
Prudviraj
Solved! Go to Solution.
Hi @Prudhviraj,
The detailed level count could be like this:
detailed_level = count('table'[Dealer])
The all the levels could be like this:
all_level = CALCULATE ( COUNT ( 'table'[Dealer] ), ALL ( 'table'[Dealer] ) )
Or you can post the expected results.
Best Regards,
Dale
Hi @Prudhviraj,
Could you please mark the proper answer as solution?
Best Regards!
Dale
Hi @Prudhviraj,
The detailed level count could be like this:
detailed_level = count('table'[Dealer])
The all the levels could be like this:
all_level = CALCULATE ( COUNT ( 'table'[Dealer] ), ALL ( 'table'[Dealer] ) )
Or you can post the expected results.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |