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)
TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi nannimora ,

It's sorry that I can't understand your requirement well, what's problem did you meet, how do you want to handle the zero and blank?

Best Regards,

Teige

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

Hi 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'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: