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

Grouped percentage of column total

 

Hello, 

 

I am new to using power BI and I'm having trouble with a calculation. I would like to get a grouped percentage, but of a column total. I have more than one group, with their total member counts by county. I would like to get the percetange of "Barnstable" , in large group, by the total. Then the same for merged market individual. I tried looking at another example under gouped percentage of row total but haven't had any luck. Can anyone help?

 

Thanks!Capture1.JPGCapture2.JPG 

 

5 REPLIES 5
Highlighted
Super User I
Super User I

Re: Grouped percentage of column total

Hi @Slimage

 

Could you let me know what is the output you are expecting based on the screen shot you have posted?

 

Also can you share some sample data on googe drive / one drive and paste the link here to enable form a solution.

 

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Highlighted
Frequent Visitor

Re: Grouped percentage of column total

Hi @CheenuSing

 

Thank you for responding!

 

I just realized what I actually need help with is finding the porportion percentage difference between two quarters.  I'm not sure how to get the sample data to you via google drive/one doc?

Capture3.JPG

 

Highlighted
Community Support
Community Support

Re: Grouped percentage of column total

Hi @Slimage,

 

I made one sample for your reference. If it doesn't meet your requirement, kindly share your sample data to me. You can upload the file to dorpbox and share the linke here.

 

Create a measure as below.

 

Measure = 
CALCULATE ( SUM ( Table1[count] ) )
    / CALCULATE (
        SUM ( Table1[count] ),
        ALLEXCEPT ( Table1, Table1[Date].[Quarter] )
    )

Capture.PNG

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
Frequent Visitor

Re: Grouped percentage of column total

Hi @v-frfei-msft

 

Thank you! Here is the link, let me know if it works! Sample Data.  I'm trying to get the porportional diffrence between quarters in percentages.

 

Thanks!

Highlighted
Community Support
Community Support

Re: Grouped percentage of column total

Hi @Slimage,

 

I cannot download the file via the link your shared, Could you please send me the file by email?

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors