Forum Discussion

ChirSidh's avatar
ChirSidh
Icon for Helper II rankHelper II
3 years ago

Add dual value to Power BI Matrix Visual

How to add two different values in a Power BI matrix visual, one at the project level and the other at the subproject level. I have Project and Sub Project (Work order) in rows and month number in c...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

ChirSidh , calculate two different measure and switch using isinscope,

 

Switch(True(),

isinscope(Table[Work Order no]), [M1],

isinscope(Table[Project]), [M2],

[M3]

)

 

How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials: https://youtu.be/smhIPw3OkKA