Forum Discussion
Count The Number Of Days In a Dataset
- Anonymous2 years ago
Hi, MichelleRoberts
Thanks SivaMani . Have you solved your problem? I read your previous reply, you can create a DAX expression similar to the following:
First, you can create a measure based on the current Table Visual, as shown in the following image:
Use a DAX expression similar to the following:
Here are the results:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MichelleRoberts , Can you try DISTINCTCOUNT () in a measure (refer the updated syntax in my previous reply) ?
I did and got the same exact results.
- SivaMani2 years agoResident Rockstar
Can you remove .[Date] from your calculation?
- MichelleRoberts2 years agoRegular Visitor
I removed the .[Date] and got this result:
- SivaMani2 years agoResident Rockstar
MichelleRoberts ,Is there any filter applied in the report and if no filter is applied what should this measure show?