Forum Discussion

u92690's avatar
u92690
Frequent Visitor
5 years ago
Solved

DRIVING CRAZY: Measure involving two table variables selected through dynamic slicers.

Hey guys,    I'm struggling  to find a solution. I have a ratio%  which is cases/tests. Both cases and tests are in different tables, but both have the same territory variables. I need to create a ...
Need Help
  • u92690's avatar
    u92690
    5 years ago

    Creating a concat of Region2 and 3 in all tables and make the relation through them would help?

u92690's avatar
u92690
Frequent Visitor
5 years ago

Creating a concat of Region2 and 3 in all tables and make the relation through them would help?

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

u92690 , yes that would also work. That's what I meant with fix your data ðŸ˜‰

  • u92690's avatar
    u92690
    Frequent Visitor
    5 years ago

    How could I do it automatically in power BI? I don't know if whether choosing concatenate or concatenatex...

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      Hey u92690 ,

       

      I would do it in Power Query already.

      Just add a new column and combine the 2 columns with an underscore. This you can do easily with a "&" in Power Query:

       

      Best regards

      Denis