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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hello, I have a table:
Type | Cost |
Plan 1 | 100 |
Plan 1 | 50 |
Plan 2 | 125 |
Plan 2 | 75 |
Actual | 100 |
Actual | 65 |
I have two measurements :
Total Plan Cost = Calculate(SUM(CostTable[Cost]), CostTable[Type] <> "Actual")
Total Actual Cost = Calculate(SUM(CostTable[Cost]), CostTable[Type] = "Actual")
And I want to make a third measurement that calculates % spent of plan for each plan by dividing the actual cost with the cost plans. I do not want the measure to calculate actual cost / actual cost. This measure along with the others I want to put into a matrix similar to:
But under each type column the % spent should appear except for the actual cost column.
Is there any way to do this?
Also is there anyway to customly order the columns ?
Thanks a lot!