Forum Discussion

ChainSpart's avatar
ChainSpart
Frequent Visitor
5 years ago
Solved

Help filter and results

Hello there,   I'll start by saying that I'm totally new with PowerBI, so I apologize if the answer has already been posted, I couldn't find it.   So here it is :   My data source is a database...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    ChainSpart , You have do this for each measure, you need

     

    calculate(sum(MyviewB[Value]), filter(MyviewB, MyviewB[colNAME2] in values(MyviewA[colNAME1])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ChainSpart , You have do this for each measure, you need

 

calculate(sum(MyviewB[Value]), filter(MyviewB, MyviewB[colNAME2] in values(MyviewA[colNAME1])))