Forum Discussion
Count The Number Of Days In a Dataset
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.
Can you remove .[Date] from your calculation?
I removed the .[Date] and got this result:
MichelleRoberts ,Is there any filter applied in the report and if no filter is applied what should this measure show?
The only filter is that the transaction date is in February. I want it to return the number 26 since there were 26 days where we had transactions in the month of February. Does that make sense?
Where is the Transaction Date = February applied? Is the filter applied at the visual level? If yes, it won't carry the filter to other visuals. You may need to add it as a slicer and apply the filter.