Forum Discussion

Greatbi1's avatar
Greatbi1
Frequent Visitor
6 years ago
Solved

Issue with calculated column - sum in unique

  Hi I have raw data as below. Trying hard to get pivot as shown in second image. Product column has a slicer.    
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Greatbi1 ,

    You can create a measure to get total volume affected--base on unique product volume just like below:

    Total volume effect = 
VAR _tab =
    SUMMARIZE (
        'Products',
        'Products'[part group],
        'Products'[Product],
        "price", MAX ( 'Products'[volume of product] )
    )
RETURN
    SUMX ( _tab, [price] )

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greatbi1 ,

You can create a measure to get total volume affected--base on unique product volume just like below:

Total volume effect = 
VAR _tab =
    SUMMARIZE (
        'Products',
        'Products'[part group],
        'Products'[Product],
        "price", MAX ( 'Products'[volume of product] )
    )
RETURN
    SUMX ( _tab, [price] )

Best Regards

Rena