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.
I am calculating percentage of product values as below.
Prod % Value
A 5%
B 4%
C 10%
D 8%
E 9%
F 3%
G 11%
H 16%
I 18%
other 12%
But when I do Top 5 or exclude other, the percentage values shouldn't change, not sure how to get it done.
%Value is calculated as sum(value)/Total(Value)
Any thought.
Thanks,
Solved! Go to Solution.
@Anonymous
Have a look at the attached pbix file which shows the Top 5 applied on average.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
@Anonymous
Add a filter if you want to exclude product D
Percentage = SUM ( Table[value] ) / CALCULATE ( SUM ( Table[Value] ), All(Table[Prod]), FILTER('Table' , Table[Prod] <> "D") )
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |