cancel
Showing results for
Search instead for
Did you mean:
Helper I

## Specific filter doubt

Hello everyone!

Any help here is appreciated! Considering the following table example:

The current report is running the VALUE column with a standard SUM formula and is filtered by the COUNTRY column with a filter visualization.

I'd like to know if it's possible (and how to) to add on the formula the following context: if the filter equals "Brasil" then add 100.

Thx in advance,

Diego

1 ACCEPTED SOLUTION
Microsoft

Hi @Tulio_DL,

Please new a measure:

```Total Value =
IF (
CALCULATE ( ISFILTERED ( Table1[Country] ), ALLSELECTED ( Table1 ) ),
IF (
SELECTEDVALUE ( Table1[Country] ) = "Brazil",
SUM ( Table1[Value] ) + 100,
SUM ( Table1[Value] )
),
SUM ( Table1[Value] )
)```

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Microsoft

Hi @Tulio_DL,

Please new a measure:

```Total Value =
IF (
CALCULATE ( ISFILTERED ( Table1[Country] ), ALLSELECTED ( Table1 ) ),
IF (
SELECTEDVALUE ( Table1[Country] ) = "Brazil",
SUM ( Table1[Value] ) + 100,
SUM ( Table1[Value] )
),
SUM ( Table1[Value] )
)```

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

Thank you very much @v-yulgu-msft

Helper I
Create new column instead of mesure and use this formula ->If( [Country]="Brazil", [Value]+100,[value])
Helper I

Hello Shantanu!

Thank you for participating man, what you've said is a way to do the trick.... But I still need to know if there's a way to do what I've pointed out on the original post because my data table is a lot more complex than this example.

## Helpful resources

Announcements

#### Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors