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 with multiple tables and views. Here I wanna work only with my views, and I can't alter this database.

 

I have a view A where I only need 1 column that'll give me a list of names (A, B, C, ...). Column colNAME1.

 

I have a view B that can show rows only if I have at least a WHERE clause with one of these names selected.

view B is like   ColNAME2, ColValue, ColDateTime

multiple rows will have colName2 since it has a lot of values

 

So It's like : 

SELECT * FROM dbo.MyViewB WHERE  colNAME2= '(value from colNAME1)'

 

Now I want to translate it in Power BI.

So I've added a Slicer, with my names data on it. I've configured it as a dropdownlist where I can select only 1 name.

I've added a table connected to my second view.

But I don't know how to link them... I though it'd be automatic since when I am on my table, the filter button on top shows that the name selected in the slicer is applied, but I still get an error and no data are shown.

 

Anyone can help please ?  

 

Thanks

 

 

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

     

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

1 Reply

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

     

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