Forum Discussion

MagikJukas's avatar
MagikJukas
Icon for Resolver III rankResolver III
3 years ago
Solved

Measure includes all date

Hi, I am trying to build a rolling 28 days measure: CALCULATE (     SUM ( OrderEntry[Total] ),         FILTER(         ALLSELECTED(OrderEntry),             (OrderEntry[Created on])>MAX(OrderEnt...
  • MagikJukas's avatar
    MagikJukas
    3 years ago

    So, the only solution I found to fix it, is to create a new table containing all dates values.

    Then I use it in my chart. this solve the issue, but I am still persuaded it can be solved my reworking the measure.
    Hopefully someone will figure this out.

     

    OrderEntry Calendar = VALUES(OrderEntry[Date2])
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

can you share some sample data which shows the problem ?

MagikJukas's avatar
MagikJukas
Icon for Resolver III rankResolver III
3 years ago

Hi johnt75 ,

here you have it: https://drive.google.com/file/d/16YS1Ky88TSFwG8RNNNebial71zL0cw2I/view?usp=sharing

 

Please be aware of:

  • I filtered out 2018
  • I selected categories 12000 amd 12100
  • first chart is your formula: you can see the first days are way too low, because they do not read 2018 data. this is not good. (as soon you add 2018, the chart looks correct).
  • second chart is my measure: you can see Jan 26 there is a drop. this does not make sense.

Ideal solution should be the second chart without those drops.

 

thanks