Forum Discussion

ttcalendar's avatar
ttcalendar
Frequent Visitor
6 years ago

DAX Measure If Row header is then

Hi,   I have a matrix table where there are 4 row headers for a P&L report. I've been looking for a measure where it would calculate "Global Var% of LY" based on the table maxtrix row name.  The c...
Need Help
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi ttcalendar 

If i understand you correct in the most common case you can try a measure like

= IF(MAX('Table'[Row level1]) = 'TOTAL NEW SALES', [Global Total Value TY]-[Global Total Value LY])/[Global Total Value TY], [Global Total Value LY]-[Global Total Value TY])/[Global Total Value LY])