Forum Discussion

Julia1234's avatar
Julia1234
Helper I
1 year ago
Solved

Filtering DirectQuery table based on import mode table - visuals

I have DirectQuery table [VendorTransaction](Vendor,Invoice,Amt) and 2 import tables: ExcludeVendor(Vendor) and ExcludeInvoice(Invoice). I would need to exclude records in DirectQuery table [VendorT...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago
    ExcludeVendorExcel = 
CALCULATE (
    SUM ( VendorTransactionMeasure[Amount] ),
    KEEPFILTERS (
        NOT VendorTransaction[Vendor] IN VALUES ( ExcludeVendor[Vendor] )
        && NOT VendorTransaction[Invoice] IN VALUES ( ExcludeInvoice[Invoice] )
    )
)

    seems to work.

Julia1234's avatar
Julia1234
Helper I
1 year ago

Thank you johnt75 , I tried this logic on visuals with different granularity  and, unfortunatelly,  this filter  returned different result for Amount.

johnt75's avatar
johnt75
Super User
1 year ago
ExcludeVendorExcel = 
CALCULATE (
    SUM ( VendorTransactionMeasure[Amount] ),
    KEEPFILTERS (
        NOT VendorTransaction[Vendor] IN VALUES ( ExcludeVendor[Vendor] )
        && NOT VendorTransaction[Invoice] IN VALUES ( ExcludeInvoice[Invoice] )
    )
)

seems to work.

  • Julia1234's avatar
    Julia1234
    Helper I
    1 year ago

    Thank you johnt75 for the details, this measure works.

  • Abhilash_P's avatar
    Abhilash_P
    Super User
    1 year ago

    Thanks johnt75 
    This solution is working.