Forum Discussion

BenSettle's avatar
BenSettle
New Member
1 year ago
Solved

Indirectly filter a table

=[ EDIT ]= Thanks for your replies, those saying it all worked as shown are correct. Unfortunately I had failed to replicate my real world example sufficiently. I don't actually have a "Training_pl...
Need Help
  • _AAndrade's avatar
    _AAndrade
    1 year ago

    Hi BenSettle,

    I replicated your data set and it's working fine. Take a look.
    According of your example the Plan 1 have Course 1 and 2 and the corresponding enrolements are 211,212,213,214,215 and 216 like I have in this picture:

    If I choose Plan2 the output must be blank because in our example we don't have any enrolement and as you can see in the picture below is working:

     

    I also attaching my pbix file so you can take a look. If you need any help please let me know.

     

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi BenSettle 

     

    Agree with _AAndrade. Your model seems to be fine.

    Regarding your concern about filter, I think it's because you don't have enough data in your Table C - enrolments table sample, your table currently only contains course information for Plan 1, so when you select Plan 1 in the slicer, nothing happens to the data in your table visual, and when you select Plan 2 or Plan 3, the table visual returns blank, as the _AAndrade reply to the screenshot shows.

    I'm trying create a table of enrolments filtered training plan,  but when I add the filter the data doesn't change.

     

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi, in your enrolments Table, Lookup the training plan into your course Table, based on idCourse, and then add a relationship between your training plan and enrolments Table.

Something like this:
In your errolments table, add calculated column and pase the following DAX:

 

Training_Plan =
VAR CourseToFind = enrolments[Course]
RETURN
    LOOKUPVALUE(
        Course[Training_Plan], 
        Course[Course], 
        CourseToFind
    )

 


Dont forget to replace the columns and table name with your owns.

if this help you, please mark this answer as solution.

Thank you