Forum Discussion

AxelllD's avatar
AxelllD
Frequent Visitor
2 years ago

Month filter weird behaviour

Hi, in our report we have a month filter, but when we select the current year there is this weird behaviour where selecting all months individually gives different results than when using the select ...
Need Help
PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi AxelllD 

Seems there are blank values in your data model.
Create a details table and bring Date field, month field, numeric field which you used in measure, and all measure in table views.
You will find where date are missing in your data model.
If not solved, please share sample pbix file (non sensitive data) link (google drive.dropbox etc)



Let me know if that works for you


If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

AxelllD's avatar
AxelllD
Frequent Visitor
2 years ago

Where would this be? I have the below DAX and it works in another dashboard, but for some reason it doesn't in this one (in this one it compares the current YTD to the whole previous year, while only the above months are selected).

 

Total Quantity = SUM(fact_sales_prof[quantity])

 

PROF_quantity_prev_year =
    IF([Total Quantity] > 0,
    CALCULATE(
        [Total Quantity],
        SAMEPERIODLASTYEAR(dim_date[Date])
    ))