Forum Discussion
Help with a filter for a table
Hello! , i'm trying to do a comparative between prices of different products.
The problem is that the main table works great but the filter for the second column that i'm comparing doesn't work. If i choose something in the filter product column 2 it doesn't appear in the main table. I'm attaching the PBI File here PBI File
Anonymous
Thanks!
3 Replies
You need to create a copy of the main table and then cross join them if you want to run this kind of comparison. Your current data model and measure definitions won't work for that scenario.
Hi lbendlin ,
I was trying with this new example (attached file) but it doesn't work neither: https://www.transferxl.com/00ZDwD8RZmtMX
Hope un can help me.
Thanks!!
Yeah, that's not what I meant. Make a full copy of the Main table in Power Query and then do the cross join between the full Main table and the full copy.
