Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

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?
 

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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