Forum Discussion

PaulMcDk's avatar
PaulMcDk
Frequent Visitor
5 years ago
Solved

SUM + DISTINCTCOUNT support

Dear community,   first, thanks for great support you are providing. I have this table with #2 different Shipment (first column).   I would like to have a measure - called "pallet number" that d...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey PaulMcDk ,

     

    thank you for the explanation, now it makes sense 😊

    The following measure should give you the result you want:

    Pallet Number NEW =
CALCULATE(
    SUM( 'Table'[Pallet Number] ),
    LEFT( 'Table'[Material], 3 ) <> "691" && 'Table'[Country Key] = "Bulgaria"
)

     

    And that's the result:

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

     

PaulMcDk's avatar
PaulMcDk
Frequent Visitor
5 years ago

that's great ! bravo