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.

Dangar332's avatar
Dangar332
Resident Rockstar
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.