Forum Discussion

LickNewin's avatar
LickNewin
Regular Visitor
2 years ago
Solved

Subtotal Divided by Row Value

I'm trying to create a measure which takes the value from each Row, and divides it by the Subtotal to give the Percentage of the Subtotal per row.    I'm currently using this measure, but it just g...
Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi LickNewin 

    Just small change in formula
    Try this 

    Measure 2= 
    var Total= CALCULATE(COUNT(Table[Reason code]),ALLEXCEPT(Table, Table[Reason code])

    RETURN
    Divide(Measure1,Total)
     

     

    It would give you expected output!
     
    I hope i answered your question!
     
Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

hi LickNewin 
Try below dax for measure

 

Measure 1= Count ( Table[Reason code])

Measure 2= 
var Total= CALCULATE(COUNT(Table[Reason code]),ALL(Table))

RETURN
Divide(Measure1,Total)
 
you can see my output

 

 

I hope I answered your question!

 

 


LickNewin's avatar
LickNewin
Regular Visitor
2 years ago

Hey Uzi,

Unfortunately that doesn't work how I wanted.

It works fine when I have all the Reason codes selected in the Filter, but as soon as I filter it, the values are wrong.