Forum Discussion

MagikJukas's avatar
MagikJukas
Resolver 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])
MagikJukas's avatar
MagikJukas
Resolver III
3 years ago

thanks johnt75, that works, until I start using a slicer.


see what happen when I select two elemets in my slicer "Category": the data shows heavy pitfalls.
this because for few given dates, the data is empty for one of the category selected. 

 

with the other formula this does not happen, however it give wrong data for the first days of the starting year.

thanks

 

johnt75's avatar
johnt75
Super User
3 years ago

can you share some sample data which shows the problem ?

  • MagikJukas's avatar
    MagikJukas
    Resolver 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