Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@ChainSpart , You have do this for each measure, you need
calculate(sum(MyviewB[Value]), filter(MyviewB, MyviewB[colNAME2] in values(MyviewA[colNAME1])))
@ChainSpart , You have do this for each measure, you need
calculate(sum(MyviewB[Value]), filter(MyviewB, MyviewB[colNAME2] in values(MyviewA[colNAME1])))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |