Dividing measures of sums from same table

314mp_M0th4 — Thu, 10 Aug 2023 14:34:18 GMT

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!

topic Dividing measures of sums from same table in DAX Commands and Tips

Dividing measures of sums from same table