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.
- MichelleRoberts2 years agoRegular Visitor
If I do that, get the following result:
If it's summed:
If I don't sum it:
- SivaMani2 years agoResident Rockstar
MichelleRoberts , Can you try DISTINCTCOUNT () in a measure (refer the updated syntax in my previous reply) ?
- MichelleRoberts2 years agoRegular Visitor
I did and got the same exact results.