Forum Discussion
Distinct Count by Date
Hello, I am trying to do a distinct count by date. Ex: When the Slicer is set to "July 2020", I want it to show 10 and count Account ID 1 once for 7/1/20 and Account ID 1 again for 7/2/20. Right...
Instead of EARLIER() use variables. Construct your measure step by step and validate the intermediate result with CONCATENATEX()
- get slicer value
- get all VALUES() of account IDs, filter as needed
- get row count
- return result