Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Visuals & measures in months without data

I have a report I am working on with various tables. I have 1 table that has events with dates in them, there a few different kinds of events. I have a second table that has hours worked for each pro...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi GolaubT,

I can't reproduce your design just based on your description, so if possible, could you please inform me more detailed information (such as your sample data and your expected output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello

     

    Event Table - Date of event/Event count/Event suptype

    Hours Table - MonthID (Format ex 201903 for March 2019)/Hours

     

    I have a Calendar table connecting to both tables to give date context to the different fields.

     

    I have one measure which is Cumulative Sum of /Event count/. I have another measure which is Cumulative Sum of /Hours/. Both these measure work as expected on a line visual, start at zero in Jan and show the change through to Sep.

     

    I have Hours every month but I dont always have events. The problem is when I use a filter for /Event suptype/ the visuals will show the correct data, however they will only show the months where there is that kind of /Event suptype/. So my visuals dont display my FR improving becuase there are more hours cumulatively and no events but if I throw in another fake event it will still calculate it correctly for the cumuative totals.