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 all, I am new to Power BI. I am trying to calculate a Rate % column based on sum(Numerator)/sum(Denominator) by Measure ID field. However, the Rate keeps calculating by the entire data set rather than slicing by Measure ID field. This is also with "Don't Summarize" on for the Rate. Please see below.
Measure ID | Num | Den | Rate % | What Rate should be |
ABA | 41765 | 43994 | 0.916468 | 0.949334 |
ART | 1091 | 1344 | 0.916468 | 0.811755952 |
BCS | 15923 | 20967 | 0.916468 | 0.759431488 |
CDC | 23792 | 23792 | 0.916468 | 1 |
Any help is appreciated.
Solved! Go to Solution.
@Anonymous
Do you want to create a measure or a column? I tried your formula to create a measure. It works fine. Could you please provide more detailed info on your issue?
RATE = SUM(Table2[NUM])/SUM(Table2[DEN])
Proud to be a Super User!
Hi @Anonymous
If you are looking for calculated colum, you can use divide them directly.
CColumn= Num/Den.
If you are looking for Measure,
Measure = SUM(NUM)/ SUM(DEN).
If you still face issue, please share more details along with the formula you use.
Thanks
Raj
@Anonymous
Do you want to create a measure or a column? I tried your formula to create a measure. It works fine. Could you please provide more detailed info on your issue?
RATE = SUM(Table2[NUM])/SUM(Table2[DEN])
Proud to be a Super User!
@ryan_mayu, thank you! I did not know the difference between the two yet. I tried creating a measure and it works perfectly. Simple fix. Thanks again.
How are you calculating Rate? Please provide the code.
Also whether it is a calculated column or a 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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |