Forum Discussion
Cyriackpazhe
Helper III
Helper IIIcontext transition
Ideally i'm supposed to get the same value at month level and year level when i write the mesure. But the year wise it is same everywhere and month wise it is same everywhere.
ValtteriN
Community Champion
Community ChampionHi,
Your matrix includes quarter level information and your dax is now removing only month and year context. You can either refer to 'calendar'[date].[month] in your ALL or e.g. user only ALL('calendar').
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
CyriackpazheHelper III
Helper IIII uploaded the wrong picture, even for quarter and year , the same is happening
- Cyriackpazhe
In this figure also, all the items are getting ranked 1 when the each quarter should have been ranked in the respective years