topic How to show two different Measures in a Matrix Table in DAX Commands and Tips

How to show two different Measures in a Matrix Table

ashrat001 — Thu, 29 Oct 2020 18:46:04 GMT

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

Re: How to show two different Measures in a Matrix Table

amitchandak — Fri, 30 Oct 2020 01:52:28 GMT

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#M428

vote for Hybrid Table

Re: How to show two different Measures in a Matrix Table

wdx223_Daniel — Fri, 30 Oct 2020 02:55:10 GMT

think you need a IF in the M2, such as M2=IF(CALCUATE([Total],DATE[YearMonthNumber]<=201911),[Total])