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 

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

     

     

     

  • LickNewin's avatar
    LickNewin
    Regular Visitor
    2 years ago

    I think i figured it out - it was missing a closing bracket after the ALLEXCEPT

    Seems to be working now!!

     

    Thanks for your help 🙂