Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter matrix colum

Hi All,   Would like to filter a Colum in a Matrix I have 3 Fileds O.Number, Size and Sale %, and would like to filter (Colum 2) Size - 1.L in matrix to display values between range >0% <=40%. I ...
Tips and Tricks
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You can create measure Filter1 like DAX below, then put the Filter1 in the Visual Level Filter of Matrix visual , setting Filter1 as "is not blank".

 

Filter1 =
var d=CALCULATE(MAX(Table1[Sale %]),FILTER(ALLSELECTED(Table1), Table1[Size] ="1.L"))
return
IF(d>0 &&d<=0.4, 1, BLANK())

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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
    6 years ago

    Hi Amy,

     

    The Colum 1.L still reflects Blank matrix  column after applying the visual filter

    Regards,

    Samuel

    • sturlaws's avatar
      sturlaws
      Icon for Resident Rockstar rankResident Rockstar
      6 years ago

      when I filter your dataset for L1 and sales between 0 and 0.4, I get this:

       



      so for your matrix, only these O.numbers should be visible?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Sturlaws,

         

        Can you share the pbix file.

         

         Regards,

        Sam