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
     
ray_aramburo's avatar
ray_aramburo
Super User
2 years ago

The issue goes beyond to the way your data is originally structured. Tasks done are separated by commas in a single row. This will restrict you in data granularity and the possibility to create and adequate data relationship. You should aim for a table structure such as:

S.No Member Task Done
1 Member 1 Task-1
1 Member 1 Task-3
1 Member 1 Task-5
2 Member 2 Task-2

 

This will allow you to create a 1 to many relationship between Task Names and Task Done. To achieve this, most likely you will need to split the column values and then unpivot those columns. 

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

    Hello ray_aramburo

    Thank you for the prompt reply. 

    The data in column "Task done" has to be in the same way as I need to see the multiple tasks done by each member, not only the task number but the task count is not constant. So the solution has to work on this database only. However I hav tried creating the helping columns by seperating each task in different column, but it could not help either.
    Thank you so much for your response. I will update here for whichever solution will work.

    Best Regards

    Arvi-Rooprai