Slicer by column names with multiple selection

[Macattack]

 

How can I do this filter?

important is that I need multiple selection option, and then I only want to see the fitters which have these trainings.  

[Anonymous · Accepted solution]

Hi @Macattack 

You can consider the following solution

1.Create a calculated table

Table 2 = var _tra1=ADDCOLUMNS(SUMMARIZE('Table',[Filter],'Table'[Training 1]),"Traning","Training 1")
var _tra2=ADDCOLUMNS(SUMMARIZE('Table',[Filter],'Table'[Training 2]),"Traning","Training 2")
var _tra3=ADDCOLUMNS(SUMMARIZE('Table',[Filter],'Table'[Training 3]),"Traning","Training 3")
var _tra4=ADDCOLUMNS(SUMMARIZE('Table',[Filter],'Table'[Training 4]),"Traning","Training 4")
return union(_tra1,_tra2,_tra3,_tra4)

2.Then create a measure

Measure = CALCULATE(MAX('Table 2'[Training 1]),FILTER('Table 2',[Training 1]<>BLANK()))

3.Then put the field of table 2 and the measure to a matrix visual

Output

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.

[lbendlin]

You are describing the functionality of Field Parameters.