Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Valores ?
VAR ASR Á CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Garantía")) + CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), ISBLANK('FY21 Rev'[Group]))/2)
VAR CONS á CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Consulting"))
TRANSACCIONES DE VAR : CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Ofertas"))
VAR TAX ? CALCULATE(SUM('FY21 Rev'[FY21 Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Tax")) + CALCULATE(SUM('FY21 Rev'[FY21 Rev]), FILTER(ALLSELECTED('FY21 Rev'), ISBLANK('FY21 Rev'[Group]))/2
VAR IFS á CALCULATE(SUM('FY21 Rev'[FY21 Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Group]-"IFS"))
devolución
SWITCH(
SELECTEDVALUE('Grupo dim'[Grupo LoS]),
"Assurance", ASR,
"Consultoría", CONS,
"Ofertas", DEALS,
"Impuesto", IMPUESTO,
"IFS", IFS)
Solved! Go to Solution.
Hola @adrlljh ,
Actualice la fórmula de su medida [Valores] como se indica a continuación:
Valores ?
VAR ASR á CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Aseguramiento")) + CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'),
'FY21 Rev'[Grupo]""--- ISBLANK('FY21 Rev'[Grupo])))/2
VAR CONS á CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Consulting"))
TRANSACCIONES DE VAR : CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Ofertas"))
VAR TAX ? CALCULATE(SUM('FY21 Rev'[FY21 Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Tax")) + CALCULATE(SUM('FY21 Rev'[FY21 Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'" ISBLANK('FY21 Rev'[Grupo])))/2
VAR IFS á CALCULATE(SUM('FY21 Rev'[FY21 Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Group]-"IFS"))
devolución
SWITCH(
SELECTEDVALUE('Grupo dim'[Grupo LoS]),
"Assurance", ASR,
"Consultoría", CONS,
"Ofertas", DEALS,
"Impuesto", IMPUESTO,
"IFS", IFS)
|
Saludos
Hola @adrlljh ,
Actualice la fórmula de su medida [Valores] como se indica a continuación:
Valores ?
VAR ASR á CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Aseguramiento")) + CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'),
'FY21 Rev'[Grupo]""--- ISBLANK('FY21 Rev'[Grupo])))/2
VAR CONS á CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Consulting"))
TRANSACCIONES DE VAR : CALCULATE(SUM('FY21 Rev'[Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Ofertas"))
VAR TAX ? CALCULATE(SUM('FY21 Rev'[FY21 Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Grupo]-"Tax")) + CALCULATE(SUM('FY21 Rev'[FY21 Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'" ISBLANK('FY21 Rev'[Grupo])))/2
VAR IFS á CALCULATE(SUM('FY21 Rev'[FY21 Rev]), FILTER(ALLSELECTED('FY21 Rev'), 'FY21 Rev'[Group]-"IFS"))
devolución
SWITCH(
SELECTEDVALUE('Grupo dim'[Grupo LoS]),
"Assurance", ASR,
"Consultoría", CONS,
"Ofertas", DEALS,
"Impuesto", IMPUESTO,
"IFS", IFS)
|
Saludos