filter in DAX based on choice from other filter/param

[limarchi7]

Hello,

I would like a dataset to be filterable in the following way:

Change = var filtered =

FILTER(dataset, dataset[column] = SELECTEDVALUE(other_dataset[column2]))

RETURN

CALCULATE ( sum(dataset[units]), filtered )

The key being "SELECTEDVALUE(other_dataset[column2])", so in other words the calculation changes based on the value the user chooses in the other filter/slicer. Is this not possible in PowerBI? I have tried it many ways, for example, selectedvalue not being embedded in the calculation itself, but pointing to a selectedvalue column. When I try it, other_dataset[column2]) seems to come up blank, instead of having the value selected from the filter.

[amitchandak]

@limarchi7 , Hope the two are not connected

Change = var filtered =
FILTER(dataset, dataset[column] in values(other_dataset[column2]))
RETURN
CALCULATE ( sum(dataset[units]), filtered )

Also, consider treatas

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

[limarchi7]

hi @amitchandak ,

Thanks for the reply. If I try doing this, it returns the entire list, instead of only the value currently selected (in the slicer).