Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Delete relationship between columns to correctly apply two filters to an array

Good people, I'm just starting to play with Power Bi with a database that I downloaded and I'm currently stuck in something, I tell you and the last thing I leave the formulas I used: I have the f...
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi Syndicate_Admin ,

 

According to your description, is it possible to provide the relevant test files. It is convenient for me to answer for you.


Looking forward to your reply.


Best Regards,
Henry

 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    Hello, good, sorry for the delay. Being a dataset that I downloaded random from the Internet it is not possible since I changed it a lot, also creating a table like the one I did above in the original post (or any table with two rows) the same thing happens, that is to say that if I have:

    NL
    1A
    2B
    3C


    the rows would be related, i.e. 1 to A and vice versa.
    As I mentioned, if I created two filters and selected, example "B", the results would automatically be skewed by "2".

    I solved it by creating two tables, one for each column, since I found no way to remove the relationship, nor do I know if there is such a possibility. The solution is simple obviously, but hey, if there is a way for this not to happen and avoid creating a table just for these cases would be great! Best regards