Creating field parameters to filter the table

Hi Anonymous 

You can refer to the following sample.

Sample data 

1.Create a slicer table

2.Create a measure and put the measure to the matrix visual filter.

Measure = VAR A=COUNTROWS(FILTER('Table',[Publish/Unpublish] IN {"Published","N/A"}))
return IF(ISFILTERED('Slicer'[CourceType]),1,IF(a>0,1,0))

3.Create a measure and put it to the course slicer visual filter.

Measure 2 = IF(ISFILTERED(Slicer[CourceType]),IF(SELECTEDVALUE('Table'[Publish/Unpublish]) in VALUES(Slicer[CourceType]),1,0),1)

4.Put the column of the slicer table to the slicer visual and put the course column to the other slicer.

Output

When the slicer is not chosen.

Choose the slicer.

Best Regards!

Yolo Zhu

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