What about if you have more than one dimension? For example, I have a sales table and a budget table but I want to filter by customer group, by product family, by region, etc
I am using this to bridge together multiple tables and I'm wondering if it is effecting performance now that my dataset is getting larger? In particular I have a table visual that keeps reporting not enough resources to display this visual when pulling in data from too many tables.
Hi sir, if I have 4 table each table has many to many relationships there is 2 different common column in both table, then is is possible to create one table 2 different common column
This might be resolved if you restructure your data model, maybe there is a loop either due to bidirectional filtering or complex relationship paths; or if you have DAX measures you might want to check on their dependencies. It's a logic error.
Excellent Chandeep
Thank You 🤩 so useful
Paji apne to dil jeet liya
Hindi wala
Channel bhi bana diya lots of thanks ❤
Thanks Dude
Wow. Currently i use power query to append, remove other columns,and remove duplicate to make that table. This dax is cool!
Nice! I had discoreved it myself Last year. It helps for sure 👍
TQ u
That is very awesome thank you!! 😊
What about if you have more than one dimension? For example, I have a sales table and a budget table but I want to filter by customer group, by product family, by region, etc
You are a superman 😊 of dax
What tool are you used (power pivot at excel or power pi)
you are amazing Sir, Kindly do more same videos.
u r genius bro
good one sir , thank you for sharing
Excellent
thanks man thats informative and to the point but i need to handle it in excel
Could you please make a video on creating a star schema from two flat fact tables?
It would be nice to see some tricks with CALCULATE between two facts tables too.
You can use POWER QUERY by just a few clicks..no coding.
@@apamwamba I'd love to see that.
Nice modelling topic!! But i like the idea of using Power Query...
What if there are regions in sales table that are not in budget table and I don’t want to show them in the sales table?
I am using this to bridge together multiple tables and I'm wondering if it is effecting performance now that my dataset is getting larger? In particular I have a table visual that keeps reporting not enough resources to display this visual when pulling in data from too many tables.
Hi sir, if I have 4 table each table has many to many relationships there is 2 different common column in both table, then is is possible to create one table 2 different common column
Just treat two tables at a time and bridge them using power query. So you will end up with 4 bridge tables... very complex schema but doable..
I did the same but when I am filtering the data only one source changes not the other ?
Excellent... tip 🎉thanks for sharing
but why we need to combine them, after union I am getting duplicate results again
It gave me circular reference error while creating relationship.
This might be resolved if you restructure your data model, maybe there is a loop either due to bidirectional filtering or complex relationship paths; or if you have DAX measures you might want to check on their dependencies. It's a logic error.
How is this classified as a bridge table? Isn’t this just creating a region dimension?
Why didn't you use DISTINCT instead of VALUES?
Yeah. Could have used that too
That is very awesome thank you!! 😊