replace value 0, with if isblank in measure with DAX

[Bebecirux]

hello how are you all?

I present my problem, I have a measure that returns my last cost value, but sometimes it has not been purchased for a long time and that is why the value gives me empty and I would like if you can help me include the IF ISBLANK formula for solve my problem and put a unique key value "1.01" or another

Thank you so much

[olgad · Accepted solution]

No probs,

Ultimo Nacionalizado =

VAR UltimaFechaNacionalizado =

    CALCULATE(

        MAX(CostosXProveedor[Fecha]),

        ALL(CostosXProveedor[Nacionalizado])

    )

RETURN

    If(isblank(CALCULATE(

        SUM(CostosXProveedor[Nacionalizado]),

        FILTER(CostosXProveedor, CostosXProveedor[Fecha] = UltimaFechaNacionalizado  

    ))), 1.01, 

CALCULATE(

        SUM(CostosXProveedor[Nacionalizado]),

        FILTER(CostosXProveedor, CostosXProveedor[Fecha] = UltimaFechaNacionalizado  

    ))) 

or you can write

Ultimo Nacionalizado =

VAR UltimaFechaNacionalizado =

    CALCULATE(

        MAX(CostosXProveedor[Fecha]),

        ALL(CostosXProveedor[Nacionalizado])

    )

var final=

    CALCULATE(

        SUM(CostosXProveedor[Nacionalizado]),

        FILTER(CostosXProveedor, CostosXProveedor[Fecha] = UltimaFechaNacionalizado  

    ))

Return

if(isblank(final), 1.01, final)

Watch out, depends where you are placing it, which visual. Please try

[Bebecirux]

@olgad thank very much 

you saved me. thank you very very much

[olgad]

1) You import this excel that you show and there are already blank values in the table for FOB, right? 

In power query you can right click on FOB and replace the blank values with 1.01 right click replace values -values to replace you shall write nothing leave it blank and with 1.01 

2) or when you create your measure calculation you get blank? Show the screenshot of the visual in pbi where you see blank, not excel

[Bebecirux]

@olgad Excuse my ignorance, your formula was fine, what I don't know is how to add it to my formula so that it works
where should I place the IF(ISBLANK in

Ultimo Nacionalizado =

VAR UltimaFechaNacionalizado =

    CALCULATE(

        MAX(CostosXProveedor[Fecha]),

        ALL(CostosXProveedor[Nacionalizado])

    )

RETURN

    CALCULATE(

        SUM(CostosXProveedor[Nacionalizado]),

        FILTER(CostosXProveedor, CostosXProveedor[Fecha] = UltimaFechaNacionalizado  

    ))

Thank You

[olgad]

Hi,

if(isblank(your whole calc after the word return), 1.01, your calc after return)

[Bebecirux]

@olgad 

Thank you very much for your answer

I have a problem I am very new

Could you give me a little more detail because it didn't work out?

thank you