Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Simple Cost Ratio from GL Data

Hello all, pretty frustrated with what I feel should be a simple task   I have a simple set of GL data, as seen below, where my amount is in one column, and my accounts are rows.     I the...
Cost
finance
Financial
Margin
P&L
ratio
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please have  a try.

    Create a measure.

    Total Revenue = CALCULATE(SUM('Table'[Amount]),ALLEXCEPT(gl_class,gl_class[Class ]))

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

Total Revenue = CALCULATE([Value],gl_class[Class]="Revenue",all(gl_class[Account]))