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 (O...
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi, Anonymous 

The "Rev $<> $0 AND COS $ <>$0" means when we satisfy Rev$!=0 and satisfy Cos$!=0 at the same time, we can see all Cos$=0 when Rev$!=0 is in the case according to your "After 1". So when you filter "Rev$<> $0 AND COS$ <>$0" there will be empty.

If you want to filter " Rev $ = $0 AND the COS $ = $0". You can try to select the "Rev $" is 0 and "COS $" is 0.

 

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 taking the time to reply.  My comments...

 

The Before image shows rows w/ Rev <> $0 AND w/ COS <> $0.  Therefore the After 2 image should show at a minimum those rows w/ Rev <> $0 AND w/ COS <> $0.  However the After 2 images shows no rows (an empty set).  

 

You are correct that "Rev $<> $0 AND COS $ <>$0" should include only rows w/ both <> $0.  I am trying to set filters that would apply Rev $<> $0 OR COS $ <>$0.  I am thinking that this is not possible using the PBI filter pane filtering and its conjunctive logic.  

 

Thanks again for you help.

 

Tim

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

    Hi, Anonymous 

    You are right .Only for the oringle filter pane, it cannot be realized your need "Rev $<> $0 OR COS $ <>$0".

    For your need , I have a method for you , you can try .

    Here is my test data :

    We can create a measure :

    Flag = IF([Rev $] <> 0 || [COS $] <> 0 ,1,0)

    Then wen put this measure on the "Filter on this visual" and configure it , then we will meet your need :

     

    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, I understand your point -- I had the same thought.  However, my data source is a cube using SQL Server Analysis Service database as the Get Data means.  PBI inhibits the creation of measures, columns, DAX, etc, etc when data is from the cube source.

       

      Any other ideas?

       

      Thanks.

       

      Tim

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

        Hi, Anonymous 

        Ah... You mean in your situation, it can not create measure.

        So just for the filter pane, i find no way to get the "OR" logic.And your understand is right！

        Thank for your sharing and your time.

         

        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