I have a data like below,
and need something like below:
If filtered by QTR(Q1)
if filtered by QTR(Q2)
if no filter is applied, result should be like below:
Based on the filter the Percentage should automatically calucalted on how many rows are present and then it will have to calculate %. I tried grand total of percentage but it doesnt have option to control the decimal places/presicions. and this one https://community.powerbi.com/t5/Desktop/How-to-show-percentage-column-in-matrix/td-p/166007
Go to Solution.
May be a MEASURE like
COUNT ( Table1[Rating] )
/ CALCULATE ( COUNT ( Table1[Rating] ), ALLEXCEPT ( Table1, Table1[QTR] ) )
View solution in original post
Thank you @Zubair_Muhammad for your reply.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!