Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have 4 measures that calculates Total, Completed, % Completed and Cancelled. And each one they are either filtered by the Location, or the Status.
I created each measure for each location and I have 4 matrixes. But I want to have all the measures in one matrix, one on each row, and the locations in the columns:
Each measure is filtered by the status and location:
Total is filtered by status = Closed, Completed, Assigned, Cancelled
Completed is filtered by status = Closed, Completed
% Completed is just a math operation of Total and Completed
Cancelled is filtered by status = Cancelled
Some location filters overlap:
For example:
Location 1 Total is filtered by location = location 1
Location 2 Total is filtered by location = location 1 or location 2
@amitchandak I did put it in row, but when I put the locations in the column, it does not show up. Only the total.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.