Forum Discussion
Filter a visual based on selected measure from another visual
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
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())
2 Replies
- amitchandak
Super User
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
Helper IV