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

I got the count to work as it should but now I need a formula to take the 26 and divide the qty to get how many parts per day. The issue is that I want each area to be divided by 26 but because some areas didn't have a shipment in every day, it wants to divide by the number of days where there were transactions in that area. Do you know how that can be accomplished? 

 

Anonymous's avatar
Anonymous
Not applicable
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.