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.
Hi,
I have this relationship
For some reason I can´t get persons to filter the sales table. As you can see below it is showing the total of persons, for each product in each of the purchase dates. If I do that with client, it shows the correct values.
I modified the relationships a bit, because there´s a bridge table (as you can see in the relationships screencap), but that wasn´t helping either.
Previously, the facts table was linked to the client dimension, client dimension to it´s bridge, and the bridge table to persons dimension.
I double checked every relationship, messed with crossfiltering options, etc, without any success.
any help is much appreciated.
regards!
Hi @makcim392, not easy to determine why it is not showing any values based on your description.
From your Person-table, can you find a couple of values from the column you have used for the relationship with the Monthly Sales-table, and verify that these values exists in the column in the Monthly sales-table used for the relationship?
yes, I´ve already done that. There are data available for persons in the sales table.
That is all I can think of. I can take a look at it if you share the report with me, either here in thread or in PM. Or try to recreate the issue in a sample file and share that
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |