Forum Discussion
Creating Cumulative Graphs
Did you use the date column from the calendar table in your visual and relationship is one to many single direction from the dim to fact tables? Also, since you want the cumulative (from the very first date), apply FILTER to the whole table instead of to just a specific column.
Please see the attached pbix.
Hi mick_lowe - No, the measure doesn't need to be moved. A measure can live in any table ,
The key thing is to use the Date column from the Calendar table on the visual and ensure both fact tables have active relationships to it. Moving measures to a dedicated Measures table is purely for organization and has no impact on the result.
Hope this helps.
This is correct about where measures can live but I would disagree about having to use the Date column of the Calendar table on the visual.
The Date column is used for the relationships, but any column from the Calendar table can be used for visuals, e.g. Year Month. The column used will likely change from visual to visual, depending on the granularity that you want to show.
Hi johnt75 - Good point- thanks for the clarification. I should have said to use a column from the Calendar table rather than specifically the Date column.
The appropriate column depends on the level of detail you want to display (e.g., Date, Year Month, Quarter, or Year). The key is that the visual uses the Calendar table so both fact tables are filtered consistently through the date relationships.
I hope this clarifies.