Forum Discussion

Tulio_DL's avatar
Tulio_DL
Helper I
8 years ago
Solved

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

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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

  • Shantanu00007's avatar
    Shantanu00007
    Helper I
    8 years ago
    Create new column instead of mesure and use this formula ->If( [Country]="Brazil", [Value]+100,[value])
    • Tulio_DL's avatar
      Tulio_DL
      Helper I
      8 years ago

      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.