Table Visual Filter

[Anonymous]

Hello Power BI Community

I have a problem which I am not currently able to solve so I hope someone here can help!

I have a data set that contains a list of courses that Managers and Staff have to take. The data set, among other things, has a field called "Manager" and a field that says YES or No if completed .Currently in my report I have a slicer that lists two courses: Course A needs to be completed by all staff including managers; Course B only by managers. I have a table visual that lists all the staff taht have not completed the courses.

What I would like is that when the user selects the slicer for Course B only the names that have the Manager indicator are shown. If Course A or neither are selected ALL staff that have not completed are shown. 

I amcompletely stuck on how to achieve this filter. Any help would be much appreciated.

[Anonymous]

Sorry but the data is quite sensitive and I'm prohibited from posting it here by the firm I work for. Hower I have created a mock up of what I'm trying to do. The data below shows two courses as mentioned above. I have a table visual in BI that shows the staff name, Line Manger and a few other pieces of data based on the courses not being complete. I have a slicer showing both courses. What I would like to have is if i choose Course A, ALL staff, be they manager or not, who have not completed will show in my table visual. If I choose Course B then only managers that have not completed will show in the table visual (highlighted purple in the data set above.

[ERD · Accepted solution]

@Anonymous ,

No need to show real data, you can always create some short dummy dataset to illustrate your issue. 

Anyway, it is always better to provide

1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1 to 2.

It will increase your chances to get an answer as no one wants to retype your data from an image.

For your case, if I understood you correctly, you can try this measure and use it as a filter on the visual (showElm is 1):

showElm =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( T[Course] ) = "a" && SELECTEDVALUE ( T[Complete] ) = "no", 1,
    SELECTEDVALUE ( T[Course] ) = "b" && SELECTEDVALUE ( T[Complete] ) = "no"
        && SELECTEDVALUE ( T[Mgr] ) = "yes", 1,
    0
)

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[ERD]

Hi @Anonymous ,

As a general advise, please, provide:

1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1 to 2.

How to Get Your Question Answered Quickly 

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.