Forum Discussion
Helper IVFilter latest Year values blank
Hi alexcatala,
Thank you for bringing to our attention the issue concerning blank results when applying filters for the year 2025 in your sales dashboard. After a thorough review of your DAX logic and the underlying data model structure, we have identified a probable root cause contributing to this unexpected behavior.
To validate the output of the [BoP Date] measure, we recommend adding a card visual to your report to display its current value. Once this visual is in place, apply a filter for the year 2025 and observe the result. If the card returns a blank value or displays a date that does not fall within the 2025 calendar year, this would confirm that [BoP Date] is not resolving correctly within the applied filter context and is likely the root cause of the blank sales data.
To address this, we suggest implementing a fallback mechanism within your DAX logic to ensure [BoP Date] does not return a blank.
This approach ensures that in the absence of a valid [BoP Date], the calculation will default to the current date, allowing the measure to continue functioning as expected.
Please ensure that there is an active one-to-many relationship between d_DateTable[Date] and f_DailySales[Date]. We also recommend temporarily removing any filters on Region, Country, or StoreType to isolate and further validate the behavior.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you.
Community SupportHi alexcatala,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Community SupportHi alexcatala,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.
- v-sgandrathi
Hi alexcatala,
I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.
Thank you.