Forum Discussion
show greater values with a numeric slicer
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.
CouponLEN =
VAR MINValue= MIN('LENGTH'[Value])
VAR MAXValue= MAX('LENGTH'[Value])
VAR CurrentValue=SUM('Table'[lenght] )
RETURN CALCULATE(SUM('Table'[lenght]),FILTER('Table',[lenght]<=MAX('LENGTH'[Value])&&[lenght]>=MIN('LENGTH'[Value])))
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)
Hi elois33
For the map formatting, you can try below measure and setting with the old sample file.
Color Measure = IF([CouponLEN] = 1 && [CouponWT] = 1, 10, 20)
However, I don't understand your new expected result for the matrix visual. Can you explain it more? You may provide a new sample pbix if the old one is not suitable.
BR,
Jing