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?
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.
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?
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] ) )
I cannot download the file via the link your shared, Could you please send me the file by email?