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 dear Community,
Could you help me check why my total doesn't return the right result please?
From the column Potential $, I want to return the total and it should be 2477508 but my total from this cololumn is 2259259 (coming from 1.07*2104791).
Thanks a lot for your help.
Best regards,
This is my Measure:
Measure Potential $ =
var avg_potential=[Volume]*[Average 3]
return
if(
HASONEVALUE(Plant[Unit]),
avg_potential,
SUMX(values('Table Plant[Unit]),avg_potential))
Unit | Volume | Average 3 | Potential $ | |
A1 | 525514 | 1,73 | 908860 | |
A2 | 161469 | 1,91 | 309002 | |
A3 | 121542 | 1,85 | 225162 | |
A4 | 207223 | 0,87 | 181102 | |
A5 | 109661 | 1,15 | 126602 | |
A6 | 144664 | 0,80 | 115472 | |
A7 | 137494 | 0,84 | 115384 | |
A8 | 118783 | 0,94 | 111785 | |
A9 | 81502 | 1,26 | 102720 | |
A10 | 212206 | 0,44 | 93834 | |
A11 | 88285 | 1,03 | 90888 | |
A12 | 78892 | 0,90 | 71214 | |
A13 | 117556 | 0,22 | 25483 | |
Sum | Average | Sum | ||
Total | 2104791 | 1,07 | 2259259 | Wrong result from measure |
Sum | Average | Sum | ||
Total | 2104791 | 1,07 | 2477508 | Right result |
This is your measure:
[Measure Potential $] =
SUMX(
VALUES( 'Table Plant'[Unit] ),
[Volume] * [Average 3]
)
You have to remember that variables, once set, are STATIC.
Best
D
Hello @Anonymous , Thanks for the reply but it doesn't work either.
Still get the same result 😞
I am getting the correct result, looks like your multiplication in the origianl post is incorrect.
Hi @Anonymous ,
Try this measure
Measure Potential $ =
VAR avg_potential = [Volume] * [Average 3]
RETURN
IF (
HASONEVALUE ( Plant[Unit] ),
SUMX (
'Table Plant',
avg_potential
),
SUMX (
VALUES ( 'Table Plant'[Unit] ),
avg_potential
)
)
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @harshnathani , thanks for your reply but it unfortunately doesn't work.
I end up with the same result at the end 😞
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 |
---|---|
42 | |
23 | |
21 | |
16 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |