I checked your sample file. It seems the measure is working. And I created a similar measure for weight. Both filter the matrix visual. Where did you think it is not working?
For the second question, you can set up conditional formatting for icons . Select Format style by Field value. You need to create a measure to compare the available lots with the targets or needs, which returns different colors for each scenario. And use this measure in "What field should we base this on?" box. For example,
Color measure =
SUM ( 'Table'[available amount] ) < SUM ( 'Table'[target amount] ),
You can also use Format style by rules, here is an example. The measure should be different.
Hello @v-jingzhang, thank you for responding to my problem. I was told that it will be better to create a measure rather that to filter it. And this is the measure that I was trying to do but it didnt work.
VAR MINValue= MIN('LENGTH'[Value])
VAR MAXValue= MAX('LENGTH'[Value])
VAR CurrentValue=SUM('Table'[lenght] )
On the original pbix file for example, I have values that don't correspond to my rechearch like the following screenshot.
For my map formatting I want to say if the available weight & length >= selected value on the slicer then a green color, otherwise red.
I used this measure but still didn't work:
map color = IF([CouponLEN] && [CouponWGT]= 1, 10,20)
And then I filtered on the map formatting settings telling If map color = 10 then green, if map color=20 then red.