Forum Discussion
Dax Logic
Hallo All, I have an interesting question and I hope someone can answer this. DISTINCTCOUNT('Date'[MonthinCalender]), where the Column I am counting is just a month column in a date table. If...
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,
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.