Show cumulative when there is not input or the row has blank result

RIBUZ — Mon, 22 Aug 2022 23:25:30 GMT

Hello comunity

I am struggling to create a metric that can show the cumulative number of created tickets in weekly basis when the week shows zero (no tickets created in that week). In this instance, I need to present the previous week count.

This is an extract of my data

Ticket Database

Id	*WK Year (Ticket Creation)
173498	WK23
175067	WK24
175709	WK26
175798	WK26
176120	WK26
176562	WK27
176657	WK27
175964	WK29
178399	WK30
178519	WK31
177780	WK31
178768	WK31
179015	WK32
179258	WK32
178805	WK32

And the *WK Year (Ticket Creation) column has a relationship with a full calendar data as below.

Calendar Data

WK23

WK24

WK25

WK26

WK27

WK28

WK29

WK30

WK31

WK32

WK33

Thank you very much.

Regards,

Ricardo

Re: Show cumulative when there is not input or the row has blank result

Jihwan_Kim — Tue, 23 Aug 2022 03:27:08 GMT

Hi,

I am not sure how your calendar table looks like, but please check the below picture and the attached pbix file.

Cumulate measure: = CALCULATE ( COUNTROWS ( Ticket ), FILTER ( ALL ( 'Calendar' ), 'Calendar'[Week] <= MAX ( 'Calendar'[Week] ) ) )

topic Re: Show cumulative when there is not input or the row has blank result in DAX Commands and Tips

Show cumulative when there is not input or the row has blank result

Re: Show cumulative when there is not input or the row has blank result