Forum Discussion
Dax Logic
To give you an idea, the following measure does what I want;
v-lid-msftCommunity Support
Hi Anonymous ,
When generate a summarize table, the context “ALLSELECTED()” also Evaluated, so the summarize table should like following: (if select between 1st March and 31th November)
Then the MAXX function calculate the same biggest value 3 for each row, every row have the same result because the ALLSELECTED context. If you want to get the value of Coulmn12 for current quarter, we need to filter the summarize table.
Best regards,I am not sure you understand my problem, because what you are explaining is what I expected the measure to do. It is exactly what I wanted, I wanted the maxx to evaluate over allselected so that it returns 3 always. But, this is not what my measure did, the allselected summed the total count so, in my case there are 10 quarters selected, so my measure returns 10 for each quarter selected. So it seems the allselected made the Maxx behave like a sumx over allselected dates.
Ok, no I made a mistake. So the maxx performs perfectly, but I did in fact put month as a column and this screwed up my measure. It is working fine so I am sorry.
The measure that gave me problems was;
CALCULATE(MAXX('Dates', DISTINCTCOUNT('Dates'[MonthInCalendar])) , ALLSELECTED('Dates'))The measure above gives me the total sum of all the months in the selected date range. In my case it is 29, so this measure gives me 29 over all querters. I get that row context are removed here so it counts all items over selected range, but I thought this would retain the row context and give me 3 over all quarters.Sorry about the mistake, this is actually the measure that behaved in this way