Filter by a thrird column

[Anonymous]

Hello!

I've this scenario:

Where i would like to filter my visualizations by an slicer that have the data from other table.

Cat = DISTINCT(Quantity[Category])

This generate another table:

But When I tried to filter I can not get the visualizations filter (Correctly):

Is possible to get the relation active despite the fact I've to keept the date table. Is there another option? (I've to avoid creating another table that work as a fact. Therefore I discard this idea from the beginning)

You can Download the PBI project Here: https://files.fm/u/vc5sre8g

Thanks

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this measure

Measure =
CALCULATE (
    SUM ( Units[Units] ),
    USERELATIONSHIP ( Cat[Category], Units[Category] )
)

[Anonymous]

Thanks! @Zubair_Muhammad

But with this measure. How can I slice The two tables?

I Want to filter this two visualizations by an slicer (But I wolud like to conserve the two tables independently.

The report with the meassure: https://files.fm/u/tqfx6c5x

Thanks!

[Zubair_Muhammad]

@Anonymous

If you use MEASURE in place of the Units in the first table, it will slice