use multiple selections of 2 slicers to filter visualization table and interact with data table

[Theokom]

I have a data table Product with 15000 rows.

columns are UnitID, UnitName, Type, SubType(2nd level), SubSubType(3rd level), Country, District, City, Used

I use a visualization table in report with two columns: UnitID, UnitName and two visualization slicers.

Slicer-1 is 3-level with Type, SubType, SubSubType and

Slicer-2 is 3-level with Country, District, City

Upon multiple selections of the 3 levels of the two slicers the visualization table has a few hundrends of rows.

I would like to use the UnitID of  these few hundrend rows filtered out to set the column named Used of the Product table to value 1 and all other to 0.

Is that possible.

Thank you in advanced for any idea.

Regards

Theo

[lbendlin]

No. You can only use it as a table variable inside a measure.  But at the end of the measure calculations you need to end up with a scalar value.

[lbendlin]

Filters cannot influence columns. They can only influence measures.  What you want to do is not possible.

[Theokom · Accepted solution]

Thanks for your clear answer.

Let me describe more clearly the second part of the problem.

I have a virtualization table that comes out after using the slicers.

Can I use this table as data table in DAX?

in other words can I somehow transfer the much less rows of the virtualization table to a data table in the model and use it as the other data tables in my dataset?

Thanks