Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Medida A =
Var _a = calcular ( sum(column1), filter( all (tableA[ColumnA]) , tableA[ColumnA] ="123" )
Var _b = calcular ( sum(columna1), filtrar( todo (tablaA[ColumnaA]) , tablaA[ColumnaA] ="321" )
Var _c = calcular ( sum(columna1), filtrar( todos (table_B[Column_B]) , table_B[Column_B] ="987" )
/* Aquí quería crear una nueva _final var, con ( (_a+ _b) - _c)
DEVOLUCIÓN
Medida A =
VAR _a = CALCULATE( SUM(tableA[column1]), FILTER( ALL(tableA[ColumnA]), tableA[ColumnA] = "123" ) ) )
VAR _b = CALCULATE( SUM(tableA[column1]), FILTER( ALL(tableA[ColumnA]), tableA[ColumnA] = "321" ) )
VAR _c = CALCULATE( SUM(table_B[Column1]), FILTER( ALL(table_B[Column_B]), table_B[Column_B] = "987" ) )
VAR _final = (_a + _b) - _c
DEVOLUCIÓN
INTERRUPTOR(
SELECTEDVALUE(Categoría[Categoría]),
"SWB habló", _a,
"Centro cautivo de SWB", _b,
"BPO", _c,
"final", _final
)
Gracias.