Forum Discussion

nannimora's avatar
nannimora
Icon for Helper I rankHelper I
7 years ago
Solved

Measure that don't considering zero/blank

Hi everyone, I need your help to solve my problem. I created two columns: ZZ. cTMI = IF(SYS_CREDEB_PARTITAC[Data_Fattura]<DATE(2000;01;01);0;SYS_CREDEB_PARTITAC[Importo_Incassato]*IF(SYS_CREDEB_PA...
Need Help
  • tex628's avatar
    tex628
    7 years ago

    You need to apply the following filter to both you measures:

    TMI = IFERROR(CALCULATE(SUM(SYS_CREDEB_PARTITAC[ZZ. cTMI])/SUM(SYS_CREDEB_PARTITAC[Importo_Incassato]) ,
    SYS_CREDEB_PARTITAC[ZZ. cTMI] <> 0 , 
    SYS_CREDEB_PARTITAC[Importo_Incassato] <> 0
    );0)

RMI = IFERROR(CALCULATE(SUM(SYS_CREDEB_PARTITAC[ZZ. cRMI])/SUM(SYS_CREDEB_PARTITAC[Importo_Incassato]) , 
    SYS_CREDEB_PARTITAC[ZZ. cRMI] <> 0 , 
    SYS_CREDEB_PARTITAC[Importo_Incassato] <> 0
    );0)
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

You need to apply the following filter to both you measures:

TMI = IFERROR(CALCULATE(SUM(SYS_CREDEB_PARTITAC[ZZ. cTMI])/SUM(SYS_CREDEB_PARTITAC[Importo_Incassato]) ,
SYS_CREDEB_PARTITAC[ZZ. cTMI] <> 0 , 
SYS_CREDEB_PARTITAC[Importo_Incassato] <> 0
);0)

RMI = IFERROR(CALCULATE(SUM(SYS_CREDEB_PARTITAC[ZZ. cRMI])/SUM(SYS_CREDEB_PARTITAC[Importo_Incassato]) , 
SYS_CREDEB_PARTITAC[ZZ. cRMI] <> 0 , 
SYS_CREDEB_PARTITAC[Importo_Incassato] <> 0
);0)
nannimora's avatar
nannimora
Icon for Helper I rankHelper I
7 years ago

hi tex628 ,

 

perfect, thank you.

 

:smileyhappy: