Forum Discussion

cheid_4838's avatar
cheid_4838
Icon for Helper IV rankHelper 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.

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi cheid_4838 
Because of this:

IF(ISBLANK(_Spend),0,_Spend)

The VertiPaq engine in Power BI enhances performance by skipping unnecessary calculations when processing blank (null) values. However, if a measure is forced to return zeroes instead of blanks, the formula engine may perform a full cross-join of the dimension tables in the visual, evaluating each possible combination explicitly. This can significantly increase query execution time, as opposed to scanning only the rows where relevant combinations actually exist. It may also result in unexpected data points appearing. For example, an obsolete item, which was deactivated several years ago, might still display for a selected period, but with zero values.