Can't apply filter on a matrix

[DimD]

Hello,

I have a small problem with a filter
I have 4 tables with relations.
I have created a working measure that I have placed in a matrix visualization.
So far, no problem.
Then, I wanted to see all the vehicles that have a value greater than 12 and it does not work, there are still values less than 12
On the other hand, when I do a conditional formatting, I see the fields of more than 12.
Do you have an idea?

Thank you in advance for your help

PBI example 

[Anonymous · Accepted solution]

Hi @DimD ,

Try to modify the measure as

Test = 
var _value=Sum(Journey[Duree_trajet_journee]) + (Sum(Travaux[Valeur])*24)
return IF(_value>=12,_value,BLANK())

Best Regards,

Stephen Tao

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

[DimD]

Hello  @Anonymous , 

Thank you for your reply. It works

[PC2790]

Hey @DimD ,

Does the filtering work when your remove the measure?

Could be that there is some logic in your measure that is overriding the filter.

Please review that.