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!
     
LickNewin's avatar
LickNewin
Regular Visitor
2 years ago

Hey Uzi,

It's coming up with an error that says the Syntax for RETURN is incorrect

 

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

hi LickNewin 

you missed the closing bracket ) this one