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.
Hello All,
We are not able to calculate the below requirement. Please guide us.
We want the requirement as :
a) 5 divided by 7 and the result should be 71%
b) 5 divivded by 20 and the result should be 25%
c) 16 divivded by 31 and the result should be 52%
d) 55 divided by 63 and the result should be 87%
Thanks in Advance.
Regards,
Vivek Chavan.
Solved! Go to Solution.
Hi @Anonymous
You may try to use HASONEVALUE Function to create measures to get the percent as requested. For example:
Percent1 = IF ( HASONEVALUE ( total[Index] ), MAX ( total[a] ), DIVIDE ( SUMX ( FILTER ( total, total[Index] = 1 ), total[a] ), SUMX ( FILTER ( total, total[Index] = 2 ), total[a] ) ) )
Regards,
Cherie
Hi @Anonymous
You may try to use HASONEVALUE Function to create measures to get the percent as requested. For example:
Percent1 = IF ( HASONEVALUE ( total[Index] ), MAX ( total[a] ), DIVIDE ( SUMX ( FILTER ( total, total[Index] = 1 ), total[a] ), SUMX ( FILTER ( total, total[Index] = 2 ), total[a] ) ) )
Regards,
Cherie
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |