Forum Discussion

robbinkees1's avatar
robbinkees1
Frequent Visitor
4 years ago
Solved

Exclude orders that contain a specific item

Hi all,   I need some help in excluding orders that contain a specific item ( based on a slicer ).  We have a sales master table and a sales lines table.  So sales order 1 from the sales master t...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi robbinkees1,

    Currently, you cant use a slicer to achieve the selector effect which you mentioned.
    For your requirement, I'd like to suggest you create a new table with all selected values which not have a relationship to the raw table and use it as a source of the slicer.

    Then you can write a measure to check the current value and selected value to return flags and use it on the 'visual level filter' to achieve exclude filter effects.

    Measure formula to filter selected records:

    Exclude Flag =
    VAR selected =
        VALUES ( NewTable[item] )
    VAR currItem =
        SELECTEDVALUE ( Table[item] )
    RETURN
        IF ( currItem IN selected, "N", "Y" )

    Applying a measure filter in Power BI - SQLBI
    Regards,

    Xiaoxin Sheng