Forum Discussion

EP1's avatar
EP1
Advocate IV
4 years ago
Solved

Matrix Filtering Column Items by Another Table

Hi Everyone   I have a matrix that I am struggling to filter because I want to show blanks as zeroes in the matrix.   I have two levels of master data and one fact table. If I filter by the lowes...
Need Help
  • EP1's avatar
    EP1
    4 years ago

    v-janeyg-msft I want to show blanks as zeroes - just not the items I filter out. What I will probably end up doing is adding a AName column to table B.

     

    Thanks for your help!!

EP1's avatar
EP1
Advocate IV
4 years ago

@lbendlin I am showing blanks as zeroes by changing blanks to zeroes in the measure calculation. However, my problem is that the second level master data filter works as desired when the items are added as rows, but not when added as columns.

lbendlin's avatar
lbendlin
Super User
4 years ago

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

  • EP1's avatar
    EP1
    Advocate IV
    4 years ago

    lbendlin please access the .pbix file here.

     

    I have added two matrices and two slicers showing the current behaviour (filtering using table A) and desired behaviour (currently filtering using table B but want to filter using table A):

     

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      4 years ago

      Hi, EP1 

       

      According to your needs, I think you need to use blank() instead of 0. Otherwise, 0 will be filled with data that does not exist.

      Like this:

       

      gap = IF(SUM(FactTable[Value])>0,1)

       

       

      Did I answer your question ? Please mark my reply as solution. Thank you very much.
      If not, please feel free to ask me.


      Best Regards,
      Community Support Team _ Janey

      • EP1's avatar
        EP1
        Advocate IV
        4 years ago

        v-janeyg-msft I want to show blanks as zeroes - just not the items I filter out. What I will probably end up doing is adding a AName column to table B.

         

        Thanks for your help!!