cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Slimage Frequent Visitor
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
CheenuSing Super Contributor
Super Contributor

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!
Slimage Frequent Visitor
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

 

Community Support Team
Community Support Team

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 other members find it more quickly.
Slimage Frequent Visitor
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!

Community Support Team
Community Support Team

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 other members find it more quickly.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 65 members 1,286 guests
Please welcome our newest community members: