Forum Discussion
Helper IIIDistinct count over a period
peteru9067 not sure if this is what you meant but if you just create this measure:
Appears = DISTINCTCOUNT('Table'[Date])
and put the IPL tag on the bar axis than you will get the distinct count of days for each one for every time period you will choose on an outside filter or slicer:
Helper III
Community Championpeteru9067 it looks like it's working 🙂 not like the previous photo. What is the issue?
- SpartaBI
peteru9067 I saw now you excepted the solution. That means it was sorted out?
- peteru9067
Yes..... all the solutions provided by you and others are correct...... the missing part which is critical was mentioned by amitchandak which is to ensure the date column does not have a "timestamp". so I created another column with just the date_value. Many many thanks.
- peteru9067
Yeah it isn't correct because 172-LSHH-0018 should only appear 3 times...... rather than 6
- peteru9067
How were you able to show 172-LSHH-0018 only 3 occurences....... using the same exact measures I show 6 occurences
- SpartaBI
peteru9067 great 🙂