Need help in Measure for % Calculation

[pmuralikrishna1]

Hi,

I have a data like below,

Name	Rating	QTR
ABC	5	Q1
CDE	6	Q1
ABC	6	Q2
BCD	6	Q2
CDE	3	Q2

and need something like below:

If filtered by QTR(Q1)

QTR	Rating	Percentage
Q1	5	50%
Q1	6	50%

if filtered by QTR(Q2)

QTR	Rating	Percentage
Q2	3	44%
Q2	6	66%

if no filter is applied, result should be like below:

Rating	Percentage
5	20%
6	60%
3	20%

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

[Zubair_Muhammad · Accepted solution]

@pmuralikrishna1

May be a MEASURE like

Measure =
COUNT ( Table1[Rating] )
    / CALCULATE ( COUNT ( Table1[Rating] ), ALLEXCEPT ( Table1, Table1[QTR] ) )

[pmuralikrishna1]

Thank you @Zubair_Muhammad for your reply.

It worked!