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've been attempting to add the value of 2 columns together into one column called Percentage, but have had no success. Here's the formula I am using:
Percentage = CALCULATE(SUM(Appearances[Winner]) / Appearances[Loser]+Appearance[Winners)
What am I doing wrong?
Thanks!
Solved! Go to Solution.
I bet you got an incredibly long error message with a long list of possible reasons why your measure would not work.
This message means you can only reference a column (like Appearances[Loser]😞
- when a row context exists (in the second argument of a FILTER, SUMX, ...., function)
- in an aggregate function like SUM, MIN, MAX, ...
- inside functions like VALUES, ALL, DISTINCT, FILTERS ...
In your case, you probably meant, :
CALCULATE( SUM(Appearances[Winner])
/ (
SUM(Appearances[Loser])
+SUM(Appearance[Winners)
)
)
I have one column where I added together Up and Built. Now I need to get the percentage up. But it is giving me an error. What am I doing wrong?
I bet you got an incredibly long error message with a long list of possible reasons why your measure would not work.
This message means you can only reference a column (like Appearances[Loser]😞
- when a row context exists (in the second argument of a FILTER, SUMX, ...., function)
- in an aggregate function like SUM, MIN, MAX, ...
- inside functions like VALUES, ALL, DISTINCT, FILTERS ...
In your case, you probably meant, :
CALCULATE( SUM(Appearances[Winner])
/ (
SUM(Appearances[Loser])
+SUM(Appearance[Winners)
)
)
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |