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
     
Anonymous's avatar
Anonymous
Not applicable
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
    New Member
    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
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi arvi-rooprai ,

       

      Please find Find in the filter and set the value to "is 1".

       

       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
        New Member
        2 years ago

        Hi v-tianyich-msft

        Thank you so much - it finally worked. ğŸ˜Š

        One more help - in continuation of this if I may ask?

        In my actual table, I have some additional visuals in my report like "Card" that displays the count of selected members in Table-1.

        Ideally when we select a task name in Table-2, the data in Table-1 gets updated and the count of members (displayed in Table-1) should also be updated - but this is not happening right now.

        I am sharing another snapshot. Though this is a minor requirement, but if it get's resolved then it would be very helpful.

        Best Regards

        Arvi-Rooprai