Forum Discussion

jbaisley's avatar
jbaisley
Icon for Helper I rankHelper I
3 years ago

Slicer Select to create flag from other table

Hello team,   I have looked through multiple questions and responses but could not quite replicate the solutions given. The closest answer was this: How to apply a slicer from one table to another...
Tutorial Requests
jbaisley's avatar
jbaisley
Icon for Helper I rankHelper I
3 years ago

Thanks goncalogeraldes. I don't have an existing measure as the data set is wide format I am calling out rows that match the authority name. It would be very time consuming to make a measure for each graphic and then a second for neighbour selection. Ideally it would be a binary flag in existing data meaning I could simply pull the column though as a group and then aggregate ethe values I need by that group then and there. If it helps to restate my question. How can I have a dynamic measure/ column appear in Dataset1 when a slicer selects an authority in DataSet 1, such that a group of authorities is selected from Dataset2 so that they can be used a legend in graphics. In theory the measure should just be a list of place names, should it not?

jbaisley's avatar
jbaisley
Icon for Helper I rankHelper I
3 years ago

I may have solved it. Then use this measure as the legend? It gives me the right output. Its where it can be used as intended.

Measure = var  a = VALUES(Data Set 1[Authority])
return
IF(MAX(Data Set 2[Authority]) in a, 1,0)