Forum Discussion
Calculating in visualisation
Hey Anonymous ,
as far as I would guess, the subtraction has to happen on a row level in the table. For that reason you have to use SUMX, which iterates over each row.
The following measure would go row by row and subtract forecast from capacity and build a sum at the end:
Accuracy = SUMX ( myTable, myTable[Capacity] - myTable[Total Forecast] )
Is that what you need?
If not, could you give me an example how the result should look like?
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Hey selimovd ,
It didn't work. For example the first result of the row gives me 15. But 48-11 should be 37.
Hey Anonymous ,
so you don't want it on a row level 😉
In that case you can just subtract:
Accuracy = SUM ( myTable[Capacity] ) - SUM ( myTable[Total Forecast] )If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic