Forum Discussion

Fusilier's avatar
Fusilier
Helper III
2 years ago
Solved

Help with total measure

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 sh...
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

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