cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pmuralikrishna1
Frequent Visitor

Need help in Measure for % Calculation

Hi,

 

I have a data like below,

 

NameRatingQTR
ABC5Q1
CDE6Q1
ABC6Q2
BCD6Q2
CDE3Q2

 

and need something like below:

If filtered by QTR(Q1)

QTRRatingPercentage
Q1550%
Q16

50%

 

if filtered by QTR(Q2)

QTRRatingPercentage
Q2344%
Q2666%

 

 

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

RatingPercentage
520%
660%
320%

 

 

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
Highlighted
Super User III
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

View solution in original post

2 REPLIES 2
Highlighted
Super User III
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

View solution in original post

pmuralikrishna1
Frequent Visitor

Re: Need help in Measure for % Calculation

Thank you @Zubair_Muhammad for your reply.

 

It worked!

 

Helpful resources

Announcements
New Ranks Launched March 24th!

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!

‘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

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