topic Re: context transition in DAX Commands and Tips

context transition

Cyriackpazhe — Thu, 13 Feb 2025 05:49:41 GMT

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.

Re: context transition

ValtteriN — Thu, 13 Feb 2025 07:11:46 GMT

Hi,

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/

Re: context transition

Cyriackpazhe — Thu, 13 Feb 2025 07:25:01 GMT

I uploaded the wrong picture, even for quarter and year , the same is happening

Re: context transition

Cyriackpazhe — Thu, 13 Feb 2025 07:27:45 GMT

In this figure also, all the items are getting ranked 1 when the each quarter should have been ranked in the respective years