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 all button (see below, everything is selected but for some reason the select all square is not checked, like there are some hidden months).

 

We have some measures comparing the current numbers to those last year and when the months are selected as below it shows them correctly (this year until May vs last year until May), but when select all is used it compares this year until May to the full previous year. Anyone know or has seen this before? Thanks!

 

 

Need Help

2 Replies

  • 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])
          ))