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,
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 calculate a new column?
I want a new column 'Accuracy'. This through 'Capacity' minused by 'Total Forecast'. In conclusion I am not able to use this in the data.
Thanks in advance.
Anonymous what do you mean you are not able to?
How does the desired report looks like?
Did you try to write this measure:
Accuracy = SUM('Table'[Capacity]) - SUM('Table'[Total Forecast])
Didn't work man. The result needs to be 48-11 = 37 and not 15. Do you got another idea?
Capacity and total forcast are measures?