Forum Discussion
Edit Interactions - result not as expected
Hello! I'm new to Power Bi and also to the forum
Why the syntax "MonthMinorFat = MINX(TOPN(1,ADDCOLUMNS(VALUES('d_Calendar'[Name of the Month]),"CMV",[09 CMV]),[09 CMV],ASC),'d_Calendar'[Name of the Month])" - returns a month that is outside the possible range once the "Month" filter has no interaction with this searched answer (the name of the month with the lower 09 CMV measure)?
The measure [09 CMV] has values only from January to June - and the Calendar dimension has all the months of the year. But the answer appears as August!!
Someone can help me? Thanks in advance...
1 Reply
Hello RenatoMartins ,
so when dealing with Minx, it will get the minimum value in the calendar data as specified and not with the measure selection.
try using All function, read more about it https://learn.microsoft.com/en-us/dax/all-function-dax
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
