Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago

Multiple Filter from Mutiple Tables

Hello, I have 2 tables Table 1 and Table 2 both have join conditions Table1.Column1 = Table 2.Column2   I Need to create a meassure to count Count(Table1.Column3) with the follwing filters Tabl...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi sabeensp ,

I created a measure you can have a try.

Measure = CALCULATE(COUNT(Table1[Column3]),FILTER(Table1,Table1[Column 5] = "Red" && Table1[Column 6] = "Large" && MAX(Table2[Table 2.Column 3])<> BLANK()))

If this is not what you want, can you please post some sample data and the expected result?

 

Best Regards,

Xue

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

  • sabeensp's avatar
    sabeensp
    Icon for Helper IV rankHelper IV
    7 years ago

    v-xuding-msft 

     

    But what if, ID 3 and 4 both have the same values in all the columns?