Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter by a thrird column

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

 

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    Try this measure

     

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

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Anonymous

     

    Try this measure

     

    Measure =
CALCULATE (
    SUM ( Units[Units] ),
    USERELATIONSHIP ( Cat[Category], Units[Category] )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Zubair_Muhammad
        Community Champion
        7 years ago

        Anonymous

         

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