Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good morning,
Is there an easy measure or calculated column to calculate a column if multiple filters apply from other columns?
E.g. calculate column A when column B is filtered on 1 & column C is filtered on 2 and Column D is filtered on 3 etc. 🙂
Solved! Go to Solution.
Hello @pigsinblankets ,
yes,
calculated column = CALCULATE(Sum(A),TableName[B]=1,TableName[C]=2,TableName[C]=3)
you can replace sum with the aggregation you want.
Proud to be a Super User! | |
Hello @pigsinblankets ,
yes,
calculated column = CALCULATE(Sum(A),TableName[B]=1,TableName[C]=2,TableName[C]=3)
you can replace sum with the aggregation you want.
Proud to be a Super User! | |
User | Count |
---|---|
90 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |