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,
I'm kind a new to Power BI and want some help please. What I need to create is a measure where can calculate % of each Count Recvd/ Total Count Recvd (same as Expected Results column). I have created below measure but it gave me % Rcvd instead, what should I do to get the same results as Excpected Results column?
%PromoRecvd =
DIVIDE([CountPromoRecvd], COUNT('Data_Table'[Employee ID]))
Count EE | Count Recvd | % Rcvd | Expected Results | |
Race A | 17 | 1 | 5.9% | 2.7% |
Race B | 28 | 4 | 14.3% | 10.8% |
Race C | 59 | 5 | 8.5% | 13.5% |
Race D | 237 | 27 | 11.4% | 73.0% |
341 | 37 |
Thank you
Solved! Go to Solution.
@Anonymous
It will be along these lines.
% of total =
DIVIDE (
[CountPromoRecvd],
CALCULATE ( [CountPromoRecvd], ALLSELECTED ( 'Data_Table'[Race] ) )
)
You will have to change the name of the column in the ALLSELECTED to match your model.
Try this..
Thank you so much for your help. I tried your measure but was not able to find "Count Recievded" when I was trying to write the measure (exactly after I was writing the SUM).
@Anonymous : "Count Recievded" was the name of the column in my data source I created for testing the solution. You should have replaced that with "CountPromoRecvd". Happy to see your issue resolved.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
Thank you so much!
@Anonymous
It will be along these lines.
% of total =
DIVIDE (
[CountPromoRecvd],
CALCULATE ( [CountPromoRecvd], ALLSELECTED ( 'Data_Table'[Race] ) )
)
You will have to change the name of the column in the ALLSELECTED to match your model.
Thank you so much for your prompt action and help! This measure worked perfectly great!
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 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |