Account has 1: N relation with Prep Table and Sig Table where Sig Table has 1:N relation with Delta Table and Delta Table has 1:N relation with Gama Table.
Each Gama has either Yes or No value as Demo no Field.
We need to count of the Demo no values based on the Sig Table . The Single Sig Table record will be selected for each account on the latest modified on of the Sig Table record grouped by Category in the same SIG table.
A Power BI matrix report need to create by adding the Account and Demo no value.
Also the matrix report calucalte the total of the Prep Table record based on the category on the same table and again modified by latest .
The category in the SIG table and Prep are same type but they may contain differnt values based on the record.
How to create Matrix report as below with considering the relationship ?
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
