Filter a not related table using same filters/slicers

[varelapablo90]

Hello community

I would like to know if it is somehow possible to filter a table by using slicers from my model despite the table I am insterested does not have any relationship with the other existing tables.

Model is in the screenshot below, and the table I am interested to filter is the one called Threshold

My end result should be an analysis as follows but being able to filter by columns from the other tables.

[johnt75 · Accepted solution]

Replace the Inv_Threshold and Value_Threshold calculated columns with measures, that way they will still respond to filters or slicers on the other tables, e.g.

Inv_Threshold = CALCULATE( COUNTROWS(T_RawData_Azure), T_RawData_Azure[Amount_in_EUR] <= SELECTEDVALUE( 'Thresholds'[Threshold]) )

[varelapablo90]

Thanks (L)