Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

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])



Showcase Report – Contoso By SpartaBI


      

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Didn't work man. The result needs to be 48-11 = 37 and not 15. Do you got another idea?

 

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    Capacity and total forcast are measures?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

      • SpartaBI's avatar
        SpartaBI
        Community Champion
        4 years ago

        ok, so thery are columms and you did implicit measures on them. 
        How are they aggregated in you visual? SUM / AVERAGE?
        If it's not just sum then you need to create explicit measures for them and them just reduce 1 measure from the other