Grouped percentage of column total

[Anonymous]

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! 

[CheenuSing]

Hi @Anonymous

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

[v-frfei-msft]

Hi @Anonymous,

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] )
    )

Regards,

Frank

[Anonymous]

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!

[v-frfei-msft]

Hi @Anonymous,

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

Regards,

Frank

[Anonymous]

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?