Forum Discussion
EaglesTony
Post Prodigy
2 years agoHow 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 ...
- 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!!!
NaveenGandhi
Memorable Member
2 years agoHi 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
Post Prodigy
2 years agoCan you post the code here ?
- NaveenGandhi2 years ago
Memorable Member
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)