Forum Discussion
nannimora
Helper I
Helper IMeasure 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...
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)
nannimoraHelper I
Helper IHi TeigeGao ,
I would like that when i calculate the measure TMI, it doesn't count the zero and the blank.
I'll try to explain myself better.
For example:
if u look the image, the total of the measure 1. TMI is 291,48. beacouse it count also the zero.
If i filter the table without 0, the total of 1.TMI change.
I want the total of TMI without 0 or blanks. and I don't know how I have to fix my measure.
I hope now you understand my problem.
And sorry for my english.
Regards.
tex628
Community Champion
Community ChampionYou 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)