Forum Discussion

MarshalSK's avatar
MarshalSK
Resolver I
2 years ago

Filter not applied at correct level in Matrix

Hi Folks, I am stuck in Filter part while using Matrix Table. If i apply filter "Sal>100", it should affect the data on top of the file Matrix table. Below I have give sample data, how generally PBI gives result and expected result.

 

 

TitleIdSal
a198
a2150
b125
b250
b375
c1101
c2102
d134

 

 

 

Need Help

6 Replies

  • jjrand's avatar
    jjrand
    Helper I
    2 years ago

    Hello,

     

    I'm not sure how you're getting the second table, but I tried two ways and got the expected result.

    First, by putting a visual level filter on sale

    Second, by writing the following measure

     

    Measure =
    SUMX(
        FILTER('Table', 'Table'[Sale]>100),
        'Table'[Sale]
    )
    • MarshalSK's avatar
      MarshalSK
      Resolver I
      2 years ago

      how your getting "advanced filter" option if sales is number data type?

      • jjrand's avatar
        jjrand
        Helper I
        2 years ago

        Yes, it's a whole number data type as shown below

         

        If you select your visual and see Basic filtering, click it and change to Advanced filtering. 

         

        Is this option now showing up for you?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi MarshalSK 

    Please check that did you have a another table, and the table have the same column name, and you put the field in this table to the filter? after testing, if you put the Sal field to the field, and make sure other field in the same table with the sal field, the filter will work.

    Best Regards!

    Yolo Zhu

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