Matrix Total

[Rimple_Manni]

Hi Everyone, 

Can you please help me understanding why my matrix not calculating total fo first column for Jan and Feb in Total Section and how exactly it's calcualting other two? Any help and suggested solutions will be appreciated 🙂 

[amitchandak]

@Rimple_Manni , You may be using time intelligence or row context.

You need to try a measure like

sumx(values(Date[Date]), [Your measure])

or refer: https://www.youtube.com/watch?v=ufHOOLdi_jk

[Rimple_Manni]

@amitchandak Thanks for that - I have sorted that, can you please suggest if we need to show maximum no out of all months as a total instead of summing up 1st or 2nd month - how we can do that? For example - If Jan = $200 and Feb = $ 400, I want to show only total as $400, however in months I want to show as seperately.