Forum Discussion
Difference between two Categories value - Matrix Table
Hi Team,
I have created Matrix table and wants to show difference between two cateories values.
The below table Catefories for App and Web is single column and wants to show Diff column is App-Web values.
kindly advise me.
Thanks
DK
Hi DKM_83
You can create 3 measures and use them, as "values".
(you don't need to put anything in "columns")1. For app
App = calculate( sum('your table name[your value column]), 'your table name[category] = "App")
2. For Web
Web= calculate( sum('your table name[your value column]), 'your table name[category] = "Web")
3. For diff
Diff = [App]-[Web]If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
Hi DKM_83
You can create 3 measures and use them, as "values".
(you don't need to put anything in "columns")1. For app
App = calculate( sum('your table name[your value column]), 'your table name[category] = "App")
2. For Web
Web= calculate( sum('your table name[your value column]), 'your table name[category] = "Web")
3. For diff
Diff = [App]-[Web]If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly