Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Cumulative Total and Cumulative %

I have this cumulative DAX function that is supposed to show the number of days it takes for items to be delivered. But the output doesn't look right i.e. I expect the cumulative % to be highe...
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Just change the measure to this

    Count:=COUNTROWS(RawData)
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

So not sure that I am reading this right, but do you average the weeks for the month?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

No average, I did a manual SUM as a check for my existing measure. The [Delivery] column is a date field which I have linked to a calendar table which I use to break down the dates by day, week, month, etc

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous ,

    So, here is the EXCEL File. Cumulative  Hopefully you can look at that and it will be a tool to figure it out.  Or maybe you can duplicate the measures, using your own table.  This table is the one that you posted for me.
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Nathaniel_C it still didn't work when I transfered your measure to my data model and I know the reason why. Your measure works perfectly fine but NOT when DATE filters are applied. If you recall my initial measure, it included DATE filter in it. Are you able to edit your measure to include DATE filter in it?

       

      Here is link to your original Excel file including full dataset that I have added to it. I also added a linked calendar table.