Forum Discussion

hcvora's avatar
hcvora
New Member
2 years ago
Solved

Need help with DAX calculation

Hi All,   Need help with DAX formula to calculate productive store days with below sample data   Meaning of productive store days: >=10 units billed (of any Fruit) to a store on a day.   For be...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi hcvora 

     

    You can try below measure.

     

     

     

    productive store days = 
COUNTROWS(
    FILTER(
        SUMMARIZE('Table','Table'[Store],'Table'[Date],"Units",SUM('Table'[Sales units])),
        [Units]>=10
    )
)

     

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

     

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

Hi hcvora 

 

You can try below measure.

 

 

 

productive store days = 
COUNTROWS(
    FILTER(
        SUMMARIZE('Table','Table'[Store],'Table'[Date],"Units",SUM('Table'[Sales units])),
        [Units]>=10
    )
)

 

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~

 

hcvora's avatar
hcvora
New Member
2 years ago

This worked! Thanks a lot.