Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 one puts this measure over the month column you get a count of 1 for each month, which makes sense, if one puts this over quarters, one gets 3 over every full quarter and maybe a 1 or 2 at the start or end or you selected date range depending on whether it includes a full of partial quarter. But, because I wanted the count to return 3 always when reporting over quarters, I decided to change the measure as follows,
To give you an idea, the following measure does what I want;
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,
The measure that gave me problems was;
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.
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.
Correction, in my summarize funciton I actually put the quarter and not the month.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |