Forum Discussion
Matrix Table
Hello, I am trying to buld a matrix that looks more or less like this. the Total occupied units is a measure that stems from the count of all the units that have 'Yes' in the Occupied co...
Hi datagoblin77 ,
I create a table as you mentioned.
Then I create three measures.
What can I do is calculating the total by creating a measure.
total1 = 'Fact_units'[total] + 'Fact_units'[ins] - 'Fact_units'[outs]
So if you can provide me more about your table or details, I will do a further study.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.