Forum Discussion
Calculating in visualisation
Hey, I want to calculate with the data in the table in 'Report'. The data in the table is grouped by through the visualisation, so I can't use the data. How can I use the data in the table to cal...
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