Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hopefully someone can help me with this.
I want to distinct count each ID, filtered by the maximum date for each ID. So for example:
The rows which are marked yellow, need to be counted.
I want to use a measure, since it depends on the selected date in the slicer.
Hopefully someone can help me!
You can use the following DAX measure to count the distinct IDs filtered by the maximum date for each ID:
In this measure, we first use the MAX function to get the maximum date for each ID, and then use the FILTER function to filter the table to only include rows with that maximum date for each ID. Finally, we use the DISTINCTCOUNT function to count the distinct IDs in the filtered table.
Make sure to replace 'Table' with the name of your actual table. You can then use this measure in a visual along with a date slicer to get the count of distinct IDs filtered by the selected date.
Thanks for your response. However, the measure is counting the customers for the maximum date of the slicer since this are way to little ID's:
> I am selecting months in my slicer, not days.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |