Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
6 years ago

Contains

Hello everyone,   I need some help here: Two tables one virtual the other phisical. The virtual returns 18 names and the phisical 35 names I would lke to return A table with all 35 names and true o...
Need Help
Fcoatis's avatar
Fcoatis
Post Patron
6 years ago

Thank you ibarrau ,

 

But I cant create relationships. My data model is more complex than the sample. The problem I cant reference a variable inside

VAR currArbitro = SELECTEDVALUE(Table1[Arbitro])


IF( 'Phisical'[name] IN VALUES ( currArbitro ), "True", "False" ) 

Thats why I´d apprecite if could take a look in the file

 

Thank you so much for your time 

ibarrau's avatar
ibarrau
Super User
6 years ago

I think you are missing something. Maybe a requirement for us or a dax basic. You shouldn't use that currArbitro like you are trying to resolve in a measure. I think that's not going to work.

 

I have just updated my github with your file. Please check it. I have added a column in all tables asking for arbitro in the others and a visualization about what I think you are trying to accomplish.

 

Hope this helps because I'm getting confuse on the requirement haha.

  • Fcoatis's avatar
    Fcoatis
    Post Patron
    6 years ago

    ibarrau Thank you!

     

    I appreciate your time and effort to help me. here is the real scenario if you are still interested.

     

    Once again thanks

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    Hey, did you actually try to add my solution to your scenario? I don't know what else to do with that pbix that should be different of what I already said.

     

    Is the pbix from my github solving the problem? if not, can you try to explain the problem over the real scenario ?

     

    Regards,

  • Fcoatis's avatar
    Fcoatis
    Post Patron
    6 years ago

    Hey, yes I did but the requirements are a bit more complicated.

     

    Here I tried to explain in a document.