Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
93 | |
85 | |
78 | |
67 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |