Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My mult. of W2 column is working with this measure:
Mult. of W2 = (SUM(Merge2[InvoiceAmnt]) / SUM(Merge2[Cost+Exp Total])/100)
Solved! Go to Solution.
First of all, mate, it's not a measure you're working with but a calculated column. The stuff you think is a measure is an in-column expression.
Mult. of W2 = var __invoiceSum = SUM( Merge2[InvoiceAmnt] ) var __costMinusTimeSum = SUM( Merge2[Cost-Time] ) var __costPlusExpSum = SUM( Merge2[Cost+Exp Total] ) var __exprWhenExpensesEquals0 = DIVIDE ( __invoiceSum, __costMinusTimeSum * 100 ) var __exprWhenExpensesNotEquals0 = divide ( __invoiceSum, __costPlusExpSum * 100 ) var __result = if ( Merge2[Expenses] = 0, __exprWhenExpensesEquals0, __exprWhenExpensesNotEquals0 ) return __result
Best
Darek
First of all, mate, it's not a measure you're working with but a calculated column. The stuff you think is a measure is an in-column expression.
Mult. of W2 = var __invoiceSum = SUM( Merge2[InvoiceAmnt] ) var __costMinusTimeSum = SUM( Merge2[Cost-Time] ) var __costPlusExpSum = SUM( Merge2[Cost+Exp Total] ) var __exprWhenExpensesEquals0 = DIVIDE ( __invoiceSum, __costMinusTimeSum * 100 ) var __exprWhenExpensesNotEquals0 = divide ( __invoiceSum, __costPlusExpSum * 100 ) var __result = if ( Merge2[Expenses] = 0, __exprWhenExpensesEquals0, __exprWhenExpensesNotEquals0 ) return __result
Best
Darek
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |