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?
Go to Solution.
@jacobs it's work but i need other column to build the table
i'm looking measure only i have used below measure
View solution in original post
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
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!