Forum Discussion

jamuka's avatar
jamuka
Icon for Helper IV rankHelper IV
4 years ago
Solved

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

  • 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())