Forum Discussion
Matrix Total
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 🙂
2 Replies
Rimple_Manni , You may be using time intelligence or row context.
You need to try a measure like
sumx(values(Date[Date]), [Your measure])
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.
