Forum Discussion
Solved
Operations for Total results
Hello all, I have a question about how to do this, I have a database with daily reports of the result, I have done a lot of summarized tables in order to show Monthly and weekly reports but I can...
This is a job for a DAX measure, not Power Query (or a DAX calculated column). More detail here:
https://radacad.com/measure-vs-calculated-column-the-mysterious-question-not
If you define a measure like this:
DIVIDE ( SUM ( Table1[Actual] ), SUM ( Table1[Plan] ) )Then it should work at whatever aggregated level you show in your visual.
This is a job for a DAX measure, not Power Query (or a DAX calculated column). More detail here:
https://radacad.com/measure-vs-calculated-column-the-mysterious-question-not
If you define a measure like this:
DIVIDE ( SUM ( Table1[Actual] ), SUM ( Table1[Plan] ) )Then it should work at whatever aggregated level you show in your visual.
Thanks a lot, it works perfectly. 😀