Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

¿Cómo sumar, sub las variables dentro de una medida?

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

INTERRUPTOR(
SELECTEDVALUE(Categoría[Categoría]),

"SWB habló"_un,
"Centro cautivo SWB", _b,
"BPO",_c,
"final", _final
)


Cómo lograrlo Por favor ayuda
2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.