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!!!

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Here's my approach

  1. Create another table (Table1) of all the unique key
  2. Create the following relationships:
    1. Many to One and Active from the Key column of the Data Table to Table1
    2. Many to One and Inactive from the Parent column of the Data Table to Table1
    3. To your slicer, drag Key from the Table1
    4. To the Table visual, drag Type and write this measure

Measure = calculate(countrows(Data),userelationship(Data[Parent],Table1[Key]))

Hope this helps.