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
ibarrau's avatar
ibarrau
Super User
6 years ago

I tried to open the file but the link required permission to access.

 

The second post you are clarifying the return and it looks like a calculated column. If you want a calculated column just add the "IF" code from my previous post and ignore the rest. The if code is the exact calculated column. Like this

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

 

Hope this help

Fcoatis's avatar
Fcoatis
Post Patron
6 years ago

Weird the shared folder is public.

 

Try this : Here

    • 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.