Forum Discussion
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...
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.
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.