Forum Discussion

sakamotothais's avatar
sakamotothais
Helper III
9 years ago
Solved

FILTER ALLEXCEPT

 

Hi,

 

I need help with the filter.

I want to filter all values only where the end is "BG".

I did the formula below but it is not bringing value.

 

Please someone can help

 

CALCULATE (
SUM ( DailyBookings[Revenue] ),
ALLEXCEPT ( DailyBookings, DailyBookings[FareBasis] ),
DailyBookings[FareBasis] = RIGHT(DailyBookings[FareBasis],2 = "BG")
)

 

Thanks

Need Help
Show and Tell
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi sakamotothais,

     

    What if you just keep 'Consulta1[ProductClassCode] = "PR"' in the filter like below? :smileyhappy:

    =
CALCULATE ( SUM ( Consulta1[Revenue] ), Consulta1[ProductClassCode] = "PR" )

     

    Regards

8 Replies

  • sokg's avatar
    sokg
    Solution Supplier
    9 years ago

    I think you must use FILTER

     

    CALCULATE (
    SUM ( DailyBookings[Revenue] ),

    FILTER(
    ALLEXCEPT ( DailyBookings, DailyBookings[FareBasis] ),
    RIGHT(DailyBookings[FareBasis],2) = "BG")
    )

     

    • sakamotothais's avatar
      sakamotothais
      Helper III
      9 years ago

      I'll try to explain it clearly. In addition to filtering, "BG",

      I want it to obey other filters on the page, like filtering by date, month or time.

      When selecting the page filter. I can select by hour or by date, or by month.

      I've tried using the selected filtering way. But I could only put an argument, like filtering by time.

      I want to know if I can put more than one selected filter