cancel
Showing results for
Did you mean:
Frequent Visitor

## Need help in Measure for % Calculation

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

## Re: Need help in Measure for % Calculation

@pmuralikrishna1

May be a MEASURE like

```Measure =
COUNT ( Table1[Rating] )
/ CALCULATE ( COUNT ( Table1[Rating] ), ALLEXCEPT ( Table1, Table1[QTR] ) )```
Try my new Power BI game Cross the River
2 REPLIES 2
Super User III

## Re: Need help in Measure for % Calculation

@pmuralikrishna1

May be a MEASURE like

```Measure =
COUNT ( Table1[Rating] )
/ CALCULATE ( COUNT ( Table1[Rating] ), ALLEXCEPT ( Table1, Table1[QTR] ) )```
Try my new Power BI game Cross the River
Frequent Visitor

It worked!

Announcements