Null value in Power BI using measure

[Analitika]

Hello,

Having issue with sales comparing this year last year in percentage. I created a measure but getting null values somehow.

mok_ly = 
IF( HASONEVALUE('Date'[Metai]) ,CALCULATE ( [moketina_suma],
    DATEADD ('Date'[Date],-1,YEAR ) ) )​

How to resolve this issue?

[v-stephen-msft]

Hi @Analitika ,

You may modify your measure as 

mok_ly = 
IF( HASONEVALUE('Date'[Metai]) ,1,0 )​

Then put it in your visual and see if it returns 1 or 0.

And also add a measure as folllows into the visual to check if it returns the results.

CALCULATE ( [moketina_suma],
    DATEADD ('Date'[Date],-1,YEAR ) )

The above two actions might help you see which part is going wrong.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @Analitika ,

did you mark you date table as date table?

Otherwise you have to add an ALL('Date') to the CALCULATE.

Did you check if HASONEVALUE('Date'[Metai]) is true? So if the CALCULATE will be executed?

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[Analitika]

Yes,

Date table is used in that measure. Date[Metai] means Date[Year], I see is true 

Metai is one value.

@selimovd