Forum Discussion

PowerUser123's avatar
PowerUser123
Icon for Helper II rankHelper II
5 years ago
Solved

Matrix - Show Max as Values but Sum as Total

I have a matrix that looks like this based on my below measure:     Test = if(HASONEVALUE('Product'[ProductName]),MAX('Product'[ProductPrice]),SUM('Product'[Product Price]))   My measure...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi PowerUser123 ,

     

    Use the following measure, it will work as you expected:

     

    measurename =
SUMX (
    SUMMARIZE (
        'Product',
        'Product'[ProductName],
        "_MAXPRICE", MAX ( 'Product'[Product Price] )
    ),
    [_MAXPRICE]
)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi PowerUser123 ,

 

Use the following measure, it will work as you expected:

 

measurename =
SUMX (
    SUMMARIZE (
        'Product',
        'Product'[ProductName],
        "_MAXPRICE", MAX ( 'Product'[Product Price] )
    ),
    [_MAXPRICE]
)

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai