Forum Discussion
Helper IHow to show two different Measures in a Matrix Table
Hi Experts,
I'm new to Power BI and DAX expressions. I have a scenario where I need to show two measures M1 and M2 into a Matrix Table. In the Rows I will have 'Segments', in the Column 'Calendar Year/Month' and Values should we have M1 for say Jan 2019 to Nov 2019 months and M2 for Dec 2019. But the challenge is M2 needs to be shown against Dec 2019 but it has values for 2019 Jan to Dec 2019. I have combined both the measures into a new measure and M1 is showing correct values from Jan 2019 to Nov 2019 but M2 in column = Dec 2019 is only showing Dec 2019 values not the cumulative ones.
I would appreciate your assistance.
Many Thanks!
Tariq
2 Replies
- amitchandak
Super User
ashrat001 , Not very clear. But seems like you are looking for a Hybrid display.
Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
- wdx223_Daniel
Community Champion
think you need a IF in the M2, such as M2=IF(CALCUATE([Total],DATE[YearMonthNumber]<=201911),[Total])
