Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Tulio_DL
Helper I
Helper I

Specific filter doubt

Hello everyone!

 

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

 

Exemplo.JPG

 

 

 

 

 

 

 

 

 

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
v-yulgu-msft
Employee
Employee

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

1.PNG2.PNG3.PNG

 

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.

View solution in original post

4 REPLIES 4
v-yulgu-msft
Employee
Employee

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

1.PNG2.PNG3.PNG

 

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.

Thank you very much @v-yulgu-msft

Shantanu00007
Helper I
Helper I

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.