Forum Discussion

arvi-rooprai's avatar
arvi-rooprai
New Member
2 years ago
Solved

Table Connection Problem

Hello I have two tables in PowerBI Desktop report Table-1: Having 3 columns - S.No., Team Member and Tasks done Table-2: Having 1 column - Task Name All the tasks done by each member are shown in...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi arvi-rooprai ,

     

    I made simple samples and you can check the results below:

    Find = var _select = SELECTEDVALUE('Table (2)'[Task Names])
var _find = CONTAINSSTRINGEXACT(MAX('Table'[Task Done]),_select)
RETURN IF(_find,1,0)

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • arvi-rooprai's avatar
    arvi-rooprai
    2 years ago
    Hi v-tianyich-msft
    Thanks for the prompt reply.
    Your solution looks great and seems to solve the problem, I applied your solution and "find" measure is working, but rows in the table are not getting affected (I mean the find function shows the 0 and 1 for the selected values, but rows with 0 are also visible) - I have removed the connection in Models but still all rows are visible at all the time.
     
    Please see the snapshot:

     

    Best Regards
    Arv-Rooprai
     
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

In the Query Editor, split the task done column in Table1 by , (comma and space) and in that window itself, select Rows (in Advanced).  Now you should be able to build your visual.

  • arvi-rooprai's avatar
    arvi-rooprai
    New Member
    2 years ago

    Hi Ashish

    Thanks for the prompt reply.

    Can you share more details of what you have suggested, perhaps with screenshots to help.

     

    Best Regards

    Arvi-Rooprai