Forum Discussion

EaglesTony's avatar
EaglesTony
Post Prodigy
2 years ago
Solved

How do I get a table filled based on another table

Hi,     I have a datasource table, which has   Type            Key           Parent Solution      S123         T123 Solution      S456         T123 Feature       F123          S123 Feature   ...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    Hi EaglesTony 

    Check the attached for the solution. I have created a disconnected table for slicer and used 2 measures as visual level filter.

    If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

    Follow me on LinkedIn!!!

EaglesTony's avatar
EaglesTony
Post Prodigy
2 years ago

Can you post the code here ?

NaveenGandhi's avatar
NaveenGandhi
Memorable Member
2 years ago
EaglesTony 

below 2 measures are used as visual level filter, The slicer value comes from a disconnected table.

t1_filter =

if(SELECTEDVALUE('Table'[Key]) in VALUES(Solutions[Table_Key]),1,0)
t2_filter =

if(SELECTEDVALUE('Table'[Parent]) in VALUES(Solutions[Table_Key]),1,0)