Forum Discussion
calculate sum based on another column distinct values
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 bu...
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 meThanks
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 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