Forum Discussion
FlowViz
Helper III
4 years agoFiltering based on value in another table
Hi guys, I need your help with one of my visuals π I have this chart that has a dot for each item. Some of these items may be 'blocked' so I want to add a way to highlight those (in red): ...
amitchandak
Super User
4 years agoFlowViz , Try a measure like
measure =
var _tab = summarize(filter(Table1, Table1[blocked2] ="Y"),[workitemdid2])
return
calculate(count(Table2[value]), filter(Table2, Table2[workitemdid] in_tab))
or try to use