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
Highlighted
Frequent Visitor

## Re: Need help in Measure for % Calculation

It worked!

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors