Help with total measure

[Fusilier]

Hi,

I have this measure:

Count = COUNTROWS('All Responses (2)')

which produces this matrix:

I'm trying to create two measures and add them as new columns in the matix

  1. a measure to show for example next to the 'Fairly safe' column the 935 in each row in a new column

  2. a percentage of the total for each column divided by the grand total e.g. 935/2892, just struggling with the dax required.

So, the final matrix would look something like this:

I thought it would be dead simple to do but I'm struggling.

Can anybody help me please?

Thanks

[Greg_Deckler]

@Fusilier First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[Dangar332 · Accepted solution]

HI, @Fusilier 

Try below measures
Just Rename your Table name and column name

New col 2_Fairly safe(% measure) =
var a = calcualte([Count],removefilters(table[Age Group]))
var b = calculate([fairly safe],removefilters(table[Age Group]))
return
divide(b,a)

New col 2=

calculate([fairly safe],removefilters(table[Age Group]))

Use same way for fairly unsafe just replace fairly safe with Fairly unsafe measure

Best Regards,
Dangar

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.