Forum Discussion

msl088's avatar
msl088
Frequent Visitor
6 years ago

Select column based on slicer

Hello,   I have a situation where I want to filter an entire table based on a slicer selection. I have created 7 different boolean columns that represent whether or not that row fulfills a series o...
Need Help
Tutorial Requests
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Using the Query Editor, create a unique list of all Gkey's and related the unpivoted table and the other table to this new table with the unique list of all Gkeys.

msl088's avatar
msl088
Frequent Visitor
6 years ago

The problem is that the Gkey is also the primary key of the table, so I can't have multiple rows with the same Gkey, and unpivoting does that.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    msl088 so this is a larger modelling challenge, as Ashish_Mathur  suggested, create a table with unique gkey column and then use that table to link to this unpvitoed table and also with other tables you have in the model.

     

    Data modelling is key part of any BI report and this is exactly is what we need it here.

     

    I would ā¤ Kudos if my solution helped. šŸ‘‰ If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    āš”Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.āš”