Forum Discussion
Helper IVCount Distinct not yielding the same as Unique in Excel
you can try to create a measure
Measure = CALCULATE(DISTINCTCOUNT('Table'[date]),FILTER('Table',not(ISBLANK('Table'[date]))))
Super UserI am not sure why this happened.
I guess maybe there are some duplicated dates between different Events
Since you only have several dates, you can try not to use the measure and just display all dates in table.
if this is the reason, you can create a new column
then distinct count the new column
Helper IVYes I unfortunately need a single total so a table isn't going to suffice.
The only solution I can think of is to create a measure similar to the above for every event, then create another measure for adding the result of these measures together to get the total. That seems like quite a lot of steps for something that should be pretty straight forward though.
Is there a more global way this could be set once so that the blanks are not causing an issue in every visual added to the dashboard? Eg. like a setting that ignores all blanks by default but doesn't actually delete them since otherwise the data integrity would be effected.