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 Anonymous ,
to add a "new column" to the visual, you have to create a measure and add it to the visual.
The measure is then executed in every row with the context of the row.
The following measure should do the job:
Accuracy = DIVIDE ( 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