Forum Discussion

TomSinAA's avatar
TomSinAA
Icon for Helper IV rankHelper IV
6 years ago
Solved

Select distinct to get cost

I am trying to create a measure to get the cost for each delivery. My data looks like: Deliver Item Delivery Cost A 1 $1 A 2 $1 A 3 $1 A 4 $1 A 5 $1 B 6 $20 B ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    TomSinAA 

     

    You may try the measure below.

    Measure =
SUMX (
    VALUES ( 'Table'[Deliver] ),
    CALCULATE ( MAX ( 'Table'[Delivery Cost] ) )
)

     

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
6 years ago

TomSinAA 

 

You may try the measure below.

Measure =
SUMX (
    VALUES ( 'Table'[Deliver] ),
    CALCULATE ( MAX ( 'Table'[Delivery Cost] ) )
)