cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Responsive Resident

## 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

1 ACCEPTED SOLUTION
Super User

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 field

6 REPLIES 6
Super User

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 field

Frequent Visitor

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.35
DAX 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.35

Feel free to ask if you have any confusion.

Responsive Resident

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]))
Frequent Visitor

Sorry, it's not clear.
Are you doing(?):

A = [X] + [Y]

* (1 -([B]))

And to achieve this, should you put a parantheses as:

A = [X] + [Y]

([X] + [Y]) * (1 -([B]))
Frequent Visitor

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.

Responsive Resident

Yes, that's correct it is showing 0.35% to 2 decimal places.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors