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.
Hello I am new to DAX and I am looking for a formula that is the equivalent of a sumifs referencing another column in example =sumifs(cases,sales order,@sales order). i have tried calculate(sum(table1[cases],filter(table1,table1[sales order]), in this case I have hundreds of sales orders
sales order item cases
1 a 5
1 b 10
1 c 8
2 a 27
2. b 35
2. c 15
3 a 6
3 b 17
3. c 24
Thank you un advance
Solved! Go to Solution.
you can plot a table visual with sales order column and a measure like:
measure = sum(table1[cases])
you can plot a table visual with sales order column and a measure like:
measure = sum(table1[cases])