Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

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. 

 

rilonex_1-1653580013766.png

rilonex_2-1653580099519.png

 

 

rilonex_0-1653579986411.png

 

2 REPLIES 2
Anonymous
Not applicable

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
Community Support
Community Support

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

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (25)