Forum Discussion
Percent decrease in measure
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
Hi,
try this measure:
Measure 3 = calculate(sum('Table (3)'[A])*(1-0.0035))or for 0.35% use a column to transform it into the decimal number 0.0035 and replace that in the measure with the new fieldIf I answered your question, please mark my post as solution, Appreciate your Kudos 👍
6 Replies
Hi sraj,
Is this value coming from a column?
If this value is from a column, try this:
Measure = SUM('Table'[Column]) - SUM('Table'[Column]) * 0.35DAX needs aggregation, it can't recongnise column names directly.
If this is a constant value, you can simply do the multiply and then substract:Measure 2 = 79132267090 * 0.35Feel free to ask if you have any confusion.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]
[X] + [Y] * (1 -([B]))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.
Hi,
try this measure:
Measure 3 = calculate(sum('Table (3)'[A])*(1-0.0035))or for 0.35% use a column to transform it into the decimal number 0.0035 and replace that in the measure with the new fieldIf I answered your question, please mark my post as solution, Appreciate your Kudos 👍
