Forum Discussion
Count The Number Of Days In a Dataset
Hello!
I have a report that looks at the total number of parts produced by each of our work cells by date. I have the report filtered to the last calendar month. I need a way to come up with a count for the total number of days. Since we do not run 7 days a week and we do not run on holidays, it's not the total number of days in the month. We also have days where we shut down the plant that are not holidays. So for example, in the screenshot below, I need something that will say there are 26 days in this report's range.
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.
12 Replies
If I do that, get the following result:
If it's summed:
If I don't sum it:
MichelleRoberts , Can you try DISTINCTCOUNT () in a measure (refer the updated syntax in my previous reply) ?
