Forum Discussion

jhodasoft's avatar
jhodasoft
Frequent Visitor
3 years ago
Solved

Calculate

Good afternoon! The idea is to put zero and not blank spaces. Can someone help me?

I did the following (see image) but the filter does not recognize me and sets the entire context to zero. Thanks for the support provided.

 

  • tamerj1's avatar
    tamerj1
    3 years ago

    jhodasoft 

    Please try

    =
    IF (
    NOT ISEMPTY ( fact_saidi_saifi ),
    COALESCE (
    CALCULATE (
    DIVIDE ( [Total_afec], [min_cliente] ),
    fact_saidi_saifi[gendist] = "T"
    ),
    0
    )
    )

6 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi jhodasoft 

    in the code of your first screenshot, try to add "+0" in the end. 

    like:

    CALCULATE(...)+0

    • jhodasoft's avatar
      jhodasoft
      Frequent Visitor
      3 years ago

      FreemanZ  Thanks for answering, I did it and it keeps putting zero to everything, the filter doesn't recognize me

       

       

       

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    jhodasoft 

    Please try

    =
    IF (
    NOT ISEMPTY ( fact_saidi_saifi ),
    COALESCE (
    CALCULATE (
    DIVIDE ( [Total_afec], [min_cliente] ),
    fact_saidi_saifi[gendist] = "T"
    ),
    0
    )
    )