Filter not applied at correct level in Matrix

[MarshalSK]

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.

Title	Id	Sal
a	1	98
a	2	150
b	1	25
b	2	50
b	3	75
c	1	101
c	2	102
d	1	34

[Anonymous]

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.

[jjrand]

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]

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

[jjrand]

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?

[MarshalSK]

Thanks for the prompt responses.

I am not getting that option,using dec 2023 version. May I know which version your using.

[jjrand]

I am using December 2023 version as well. Can you please share a screenshot of what you see on the filters pane when you click on your visual? I might be able to tell the problem from that.