Forum Discussion

MichelleRoberts's avatar
MichelleRoberts
Regular Visitor
2 years ago
Solved

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 co...
Need Help
  • Anonymous's avatar
    Anonymous
    2 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's avatar
MichelleRoberts
Regular Visitor
2 years ago

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?

SivaMani's avatar
SivaMani
Resident Rockstar
2 years ago

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.