i do have this below table
i like this way in Power Bi
|Row Labels||Accepted||% completed||Dispute||% completed||Review||% completed||Grand Total|
with countx function in Power Bi measure
can anyone guide me. Heaps thansk i
Solved! Go to Solution.
You do not need a calculation. Insert a matrix visual onto the report canvas, add the AREA to Rows section and the CASE to Column selection then insert a CASE again to the Value section and set the aggregation to COUNT
HI Fowmy, thanks for replying,
I am counting how many % complted every Area by case wise. like Sydney is having 4 rows then how many % for Review, Dispute....
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.