Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous it's work but i need other column to build the table
i'm looking measure only i have used below measure
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |