Filter a visual based on selected measure from another visual

[jamuka]

I have a table which shows product availability and their forecasts.

I'd like to show ratio of "out of stock forecast amount" versus "total forecast amount".

When user select a row in this matrix, In a second matrix I want to show only the lower values then the selection in first matrix.

I created the first matrix but for second one I tried to use "Selectedvalue" function but it only works with columns not measures, so I stucked.

here is a sample file.

regards

[amitchandak · Accepted solution]

@jamuka , we can not pass measure values across

But selection can reduce the value

You can use like

measure  =

var _max = calculate([M1], allselected() )

return 

if([M1] <_max, [M2], blank())

[jamuka]

thank you @amitchandak 

it worked.

have a nice day