Forum Discussion

mtrevisiol's avatar
mtrevisiol
Icon for Helper V rankHelper V
2 years ago
Solved

Filter table based on category from other table

Hi everyone, I've got a small database like this:   My intent is to create a PowerBI report in which the user can filter the Supplier Name (from table 1), and get the QualityFactor (from tab...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, mtrevisiol 

     

    First you need to disconnect Table 1 from Table 4.

    Measure = 
IF ( SELECTEDVALUE ( Table4[IDSupplier] )
        IN CALCULATETABLE ( VALUES ( Table2[Activity] ),
            FILTER ( ALL ( Table2 ), [Supplier] = SELECTEDVALUE ( Table1[IDSupplier] ) )
        ),
    1,
    0
)

    Put measure in the filter of the view to be filtered and set it equal to 1.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
2 years ago

Hi, mtrevisiol 

 

First you need to disconnect Table 1 from Table 4.

Measure = 
IF ( SELECTEDVALUE ( Table4[IDSupplier] )
        IN CALCULATETABLE ( VALUES ( Table2[Activity] ),
            FILTER ( ALL ( Table2 ), [Supplier] = SELECTEDVALUE ( Table1[IDSupplier] ) )
        ),
    1,
    0
)

Put measure in the filter of the view to be filtered and set it equal to 1.

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.