Forum Discussion

Dvilches_'s avatar
Dvilches_
Frequent Visitor
4 years ago
Solved

Count Operating Days

Hello there,   Hope you're doing great! I have a question. I'm using a simple model that const of two tables:   FacSales DimCalendar My company move several packages in a daily basis, however...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Dvilches_, 

     

    count days if the day is greater then 15,000.

     

    Count operating days = COUNTROWS(filter(SUMMARIZE('FacTable',[Date],"sum",SUM(FacTable[packages])),[sum]>15000))

     

    Result:

    Pbix file in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Dvilches_, 

 

count days if the day is greater then 15,000.

 

Count operating days = COUNTROWS(filter(SUMMARIZE('FacTable',[Date],"sum",SUM(FacTable[packages])),[sum]>15000))

 

Result:

Pbix file in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Dvilches_'s avatar
    Dvilches_
    Frequent Visitor
    4 years ago

    You tha best! Working fine. Power Query i think that i handle it quite well, but currently i'm in the DAX journey.

     

    Thanks for your time and this solution!