Forum Discussion

cheid_4838's avatar
cheid_4838
Helper IV
1 year ago
Solved

Filter function is not filtering

I have a table that contains invoice level information.  This table is connected to three lookup tables (Division, Date, driver, and tractor). Not very complex. My goal for one of my visuals is to sh...
Need Help
  • Ashish_Excel's avatar
    Ashish_Excel
    1 year ago

    Hi,

    Does this measure work?

    _Spend = CALCULATE([Fuel Spend],'EFS Transaction Report'[all_fuel_line_item_discount]=0)

    If not, then share the download link of the PBi file and show the problem there very clearly.

AlexisOlson's avatar
AlexisOlson
Super User
1 year ago

Does it make a difference if you filter just the column rather than the whole table?

No Rebate Fuel Spend =
VAR _Spend =
    CALCULATE (
        [Fuel Spend],
        FILTER (
            VALUES ( 'EFS Transaction Report'[all_fuel_line_item_discount] ),
            'EFS Transaction Report'[all_fuel_line_item_discount] = 0
        )
    )
RETURN
    IF ( ISBLANK ( _Spend ), 0, _Spend )