Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

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,

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.