Forum Discussion
DATESMTD('Date'[Date]) wrong subtotal
i have measure Fact= CALCULATE ( [Fact] ,DATESMTD('Date'[Date]) ) but in matrix it show only last month total, how to show sum of all months in matrix?
HI Analitika,
You can take a look at the following blog to know how to use the 'if statement' to check the current row content level, then you can write a special formula as 'lbendlin' mentioned to handle the total level calculations.
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng