Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter Pane Collective Logic

Hello Members, I am hoping there is a simple answer to the following question. 

 

Do the pbi filters on the filters pane function together as conjunctioned filters (AND) or disjunctioned filters (OR)?

 

I have a pbi built using cube data.  The filter collective on the filters pane seems at times to be conjunctive and at times to be disjunctive.  I have page filters set up using both measures and dimensions in the same filter pane.  I am not getting the conjucntive result that I am looking for.

 

Any assistance would be appreciated.

 

Thanks.

9 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi ， Anonymous 

    In the "Filter" on the right in Power BI Destop, certain field names are generally placed, and these placed fields are calculated using "AND" logic. The purpose of the Filter is to modify the page's filtering context to calculate the data results under different situations.
    The "OR" logic can only be set for a single field, for example, the multi-selection of the slicer is joined by the "OR" logic, or the "OR AND" logic is changed in the "Advanced filtering" in the "Filter Pane" to filter a single field,like this:

    This means the [Column1] can equals 1 or 2 .

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello Aniya, thanks for the detailed explanation.  My understanding is/was just as you explained. 

       

      However my experience w/ the following example filter result is different from my understanding.  In the following PBI example (before and after filtering) I am trying to filter out (exclude) rows where both the Rev $ = $0 AND the COS $ = $0 (the data source is a cube and Rev/COS are both measures in the cube).  In other words I am trying to include rows where either the Rev $ <> $0 OR the COS <> $0.   The before image below shows rows before filtering and the 2 after images below show the rows after 2 filter settings.  The before image is good, the after 1 image is good, but I don't understand why the after 2 image has filtered out all rows when my filter logic should produce a result w/ 13 rows (no image provided).

       

      Before

       

      After 1 (Rev $<> $0)

       

      After 2 (Rev $<> $0 AND COS $ <>$0)

       

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Community Support
        3 years ago

        Hi , Anonymous 

        I check your shared picture. I think it works in logic.

        The (Rev $<> $0 AND COS $ <>$0) means when both Rev$<> $0 and COS$<>$0 conditions are met.

        In your After1, you can see that when the Rev$<> $0 condition is satisfied, there is no COS$<>$0 condition, so it is empty in After2.

        For the "AND" logic, it represents a case where two conditions are met at the same time, which can be understood as an intersection.

         

        Best Regards,

        Aniya Zhang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly