Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |