Forum Discussion

Sofiane85's avatar
Sofiane85
Frequent Visitor
3 years ago
Solved

sum culumns without duplicate

Good morning All, i'm new with DAX, please i need you help, i have a table of products as you can see in this image: i need to calculate the sum of the two columns (Quantite * Price) but onl...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure how your datamodel looks like, or how your desired outcome looks like, but please check the below picture and the attached pbix file.

     

     

     

    expected outcome measure: =
VAR _latestdate =
    ADDCOLUMNS (
        DISTINCT ( Data[Product ID] ),
        "@latestdate", CALCULATE ( MAX ( Data[Creation Date] ) )
    )
RETURN
    CALCULATE (
        SUMX ( Data, Data[Quantity] * Data[Price] ),
        TREATAS ( _latestdate, Data[Product ID], Data[Creation Date] )
    )
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure how your datamodel looks like, or how your desired outcome looks like, but please check the below picture and the attached pbix file.

 

 

 

expected outcome measure: =
VAR _latestdate =
    ADDCOLUMNS (
        DISTINCT ( Data[Product ID] ),
        "@latestdate", CALCULATE ( MAX ( Data[Creation Date] ) )
    )
RETURN
    CALCULATE (
        SUMX ( Data, Data[Quantity] * Data[Price] ),
        TREATAS ( _latestdate, Data[Product ID], Data[Creation Date] )
    )