Filter Table on Field That is Dependent on Slicer Selection

[burtfarlander44]

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.

[Anonymous]

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

[Selva-Salimi]

@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. 

[Selva-Salimi]

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)?

[burtfarlander44]

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.