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,
Can someone please advise on this? Probably something very silly, but I really need some input as my value in the visual is showing as '78,860,674,807' instead of what the calculator says '78,855,304,155'.
A = 79,132,267,090
B = 0.35%
Return = 78,855,304,155
How do I get this in a measure?
79,132,267,090 – 0.35% = 78,855,304,155
Solved! Go to Solution.
Hi,
try this measure:
Hi,
try this measure:
Hi @sraj,
Is this value coming from a column?
If this value is from a column, try this:
A is not a column = It is a calculated Value from a total measure i.e.
(712141429 + 78420125661) = 79,132,267,090
B 0.35% is a calculated value too and is not going to be constant.
Right now this is what I am doing
A = [X] + [Y]
Sorry, it's not clear.
Are you doing(?):
A = [X] + [Y]
A = [X] + [Y]
I am not sure if I can provide a solution to your issue, however, when I back calculate, I see it's actually 0.003432 very near to 0.35%. Is it showing 0.35% sue to 2 decimal places and the actual underlying value is different? This might be the reason for your visual showing a value different than the one in calculator.
Yes, that's correct it is showing 0.35% to 2 decimal places.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |