Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |