Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

count multiple rows together

Hi !   I have a table named ShipDetails that looks like this :   DROP ON_TIME_DELIVERY ORDERED_PRODUCT Client 1 - Order 1 OK Product 2 Client 1 - Order 1 OK Product 4 Client 2 -...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Try this.

    On time delivery (%) = 
DIVIDE(
    CALCULATE(
        DISTINCTCOUNT( ShipDetails[DROP] ), 
        ShipDetails[ON_TIME_DELIVERY] = "OK" 
    ),
    DISTINCTCOUNT ( ShipDetails[DROP] )
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

Try this.

On time delivery (%) = 
DIVIDE(
    CALCULATE(
        DISTINCTCOUNT( ShipDetails[DROP] ), 
        ShipDetails[ON_TIME_DELIVERY] = "OK" 
    ),
    DISTINCTCOUNT ( ShipDetails[DROP] )
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn