topic DAX not giving any errors but not getting the result either in DAX Commands and Tips

DAX not giving any errors but not getting the result either

Saadahmedqu — Tue, 18 Oct 2022 06:05:32 GMT

My data has years 2018 to 2021. I am comparing sales with the previous years and have created different DAX for that but for dynamic header based on selection of year, I am using below mentioned DAX but not getting the required result;

Selected value = Calendar Year (filter)

IF(HASONEVALUE('Calendar'[Year]) && SELECTEDVALUE('Calendar'[Year]) > 2018, "Selected Year = " & SELECTEDVALUE('Calendar'[Year]) & " and Previous Year = " & SELECTEDVALUE('Calendar'[Year]) -1,

IF(HASONEVALUE('Calendar'[Year]) && SELECTEDVALUE('Calendar'[Year]) = 2018, "Selected Year = 2018 and Previous Year Not present in data",

Re: DAX not giving any errors but not getting the result either

ValtteriN — Tue, 18 Oct 2022 07:54:23 GMT

Hi,

Based on my test your measure seems to be working. Here is an improved dax using variables:

Measure 20 =

var _syear = SELECTEDVALUE('Calendar'[Year])

var _ftest = HASONEVALUE('Calendar'[Year])

return

IF( _ftest && _syear > 2018, "Selected Year = " & _syear & " and Previous Year = " & _syear -1,

IF(_ftest && _syear = 2018, "Selected Year = 2018 and Previous Year Not present in data"))

End result:

If this still doesn't work I recommend cheking what filters affect your visuals. The issue might be there.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: DAX not giving any errors but not getting the result either

Saadaq — Mon, 24 Oct 2022 05:51:13 GMT

Thank you so much for your reply. I have used your solution also but even then it is not displaying result in card

The card displayed above based on selection is DAX used by me and the second card displaying cross sign is the query you provided. I think the problem is with multiple conditions based on the selection with hasvalue. There are no filters applied on visuals or page.

Below is the solution provided by you;

Selected_Year_New =

Var syear = SELECTEDVALUE('Calendar'[Year])

Var ftest = HASONEVALUE('Calendar'[Year])

Return

IF(ftest > 2018 && syear > 2018, "Selected Year = " & syear & " and Previous Year = " & syear -1,

IF(ftest = 2018 && syear = 2018,"Selected Year = 2018 and Previous Year Not present in data"))

Can this issue be solved by fixing it to min year criteria?

Re: DAX not giving any errors but not getting the result either

v-xiaotang — Tue, 01 Nov 2022 09:41:04 GMT

Hi Saadahmedqu

Thanks for reaching out to us.

please use the sample file attached below

Best Regards,

Community Support Team _Tang

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