topic Re: Filter Table on Field That is Dependent on Slicer Selection in DAX Commands and Tips

Filter Table on Field That is Dependent on Slicer Selection

burtfarlander44 — Thu, 12 Sep 2024 15:47:04 GMT

I have a slicer with 2 selections, Course and Certification. I also have a separate field called Archived that is either TRUE or FALSE.

I am trying to filter the table on the archived value based on whether Course (FALSE) or Certification (TRUE) is selected in the slicer

I have tried using an IF statement nested with a FILTER statement with no luck.

Re: Filter Table on Field That is Dependent on Slicer Selection

Selva-Salimi — Thu, 12 Sep 2024 16:26:17 GMT

Hi burtfarlander44

what did you mean "seprate field"? are the slicers come from two dimention that are not related to your fact table?! does your fact table contain two column of which has the values ( true/false and certificate/course)?

Re: Filter Table on Field That is Dependent on Slicer Selection

burtfarlander44 — Thu, 12 Sep 2024 16:42:58 GMT

By "separate" i mean a field that isn't part of the slicer. Essentially i want the slicer selection to filter the table and then based on that selection, i would like the table to be filtered further by only showing data for the true/false field designation i.e. Slicer Course would show FALSE and slicer certification would show TRUE.

Re: Filter Table on Field That is Dependent on Slicer Selection

Selva-Salimi — Thu, 12 Sep 2024 16:52:24 GMT

burtfarlander44

one easy solution is to write a modified column in your table as follows:

if ([archive] = "True" , "Certificate" , if ([archive]="false" , "Course" ))

you also can connect this modified column to your dimension which contains certificate/course or use this column in your calculations.

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

Re: Filter Table on Field That is Dependent on Slicer Selection

Anonymous — Fri, 20 Sep 2024 08:48:13 GMT

Hi burtfarlander44 ,

Has the issue been solved?
Have there been any updates? Please feel free to ask me if you have any questions!

If the issue has been resolved, can you share your solution or mark helpful responses as solutions?

Best Regards,
Dengliang Li