Forum Discussion

Schwurblini's avatar
Schwurblini
Frequent Visitor
3 years ago

Suddenly missing a month even with Data

Hi Everyone   So i ran into an issue with some measure and a column chart: As you can see I am missing a Month, there used tho be a column so it was working afew refreshes ago but lately it ...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

As there was no new data in January SUMMARIZE will not data for January and so there will be no rows in the calculated table. You could try using the below as a measure and put that onto the chart directly

Total Onboarding finished eCommerce =
VAR MaxDate =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Finished Onboarding' ),
        'Finished Onboarding'[productMapping] = "XXX"
            || 'Finished Onboarding'[productMapping] = "YYY",
        'Finished Onboarding'[registrationTime] <= MaxDate
    )
Schwurblini's avatar
Schwurblini
Frequent Visitor
3 years ago

Hi John

 

So it could be the issue that if there is no additional Data, it will simply not update? Im sorry im not 100% familiar with all the DAX calculations im doing 😄 It would be weird though, because there was Data, ive checked it in the source file.

 

Problem with your measure is, i would need to add them incrementally on top of the last month

How could i do that with the return function?

 

Also the missing bright green button will reappear? its a simply count row input, not even a measure and it disappeared as well

 

Thank you so much for your input

 

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    My measure is cumulative so it will take that into account.

    The reason your row count is missing is that the implicit measure which is created when you add that column to the chart will be translated into a COUNTROWS, or one of the other count-type functions. These return blank if there is no data, and so would not be plotted onto the chart.

    Everything points to there being no data for January. You can use the data view to look at the table you are creating with SUMMARIZE and apply date filters to only show data for January, that might help you track down the problem

    • Schwurblini's avatar
      Schwurblini
      Frequent Visitor
      3 years ago

      Hi John 

       

      Thanks for the advice

      So i checked what you said, if there is Data for January, and there is, normally added like all the months before:

       

      I tried to create a new Data Model and there it showed up normal.

       

      After checking, i deleted the filtering for products and this brought it back, so there was some issue with product mapping... I will keep you posted