Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Two tables cross/matrix calculation

I am not sure what to call this calculation but its by using the first 2 tables to get the values in the 3rd table. Can i get this done in Power BI. 

 

Thank you. 

 

 

 

 

Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Looking at this calculation but getting error. (Calculate has been used in true or false expression...)

    Incident Calc =
    CALCULATE(COUNT('incidentreport factor'[Checked]), 'incidentreport factor'[Checked], CALCULATE(COUNT('incident factor'[Checked]),'incident factor'[Checked]))
  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    What's the meaning of each column in your tables? And what do you want to calculate in the matrix? In other words, what's the numbers' meaning? I don't quite understand your scenario and requirements.

     

     

    Best Regards,

    Icey