Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
You are describing the functionality of Field Parameters.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |