calculate sum based on another column distinct values

[Anonymous]

Hi Team,

     how to find sum using another column distinct values, after unpivoting the the columns im getting results like this

i want to sum of Total column,    i need result is 3.7  but im getting 11.1

calculate the sum based on another column distinct values  How to solve this?

Thanks,

Ranga

[Anonymous]

I think what you want can be done in Power Query - Transform - Group by.

When I do that I get the results you seek: 

I used these settings for the step:

Let me know if it works

[Anonymous · Accepted solution]

@Anonymous    it's work but i need other column to build the table

i'm looking measure only i have used below measure

Total sales = SUMX(DISTINCT('Table'[Category]),MAX('Table'[Total]))

it's work for me

Thanks