Forum Discussion

Advocate I

3 years ago

Solved

Display Cumulative Percentage Over Time - Line Chart

I have a list of SAP Notifications. Each Notification eventually gets a Work Order assigned to it as the job is planned. And I have a date column for when the Work Order is created Eventually ever...

Greg_Deckler
3 years ago
bgierwi2 OK, well, this is going to depend a bit on what date you use for your x-axis and whether you want to count all Notifications every time or just those that were created prior to the specific date on the axis. Making some simplifying assumptions and using the only date in your sample data it should look something like this:

Measure = VAR __Date = MAX('Table'[Date Work Order Created]) VAR __AllCount = COUNTROWS(ALL('Table')) VAR __CurrentCount = COUNTROWS(FILTER(ALL('Table'),[Date Work Order Created] <> BLANK() && [Date Work Order Created] <= __Date)) RETURN DIVIDE(__CurrentCount, __AllCount, 0)

Greg_Deckler

Community Champion

3 years ago

bgierwi2 OK, well, this is going to depend a bit on what date you use for your x-axis and whether you want to count all Notifications every time or just those that were created prior to the specific date on the axis. Making some simplifying assumptions and using the only date in your sample data it should look something like this:

Measure =
  VAR __Date = MAX('Table'[Date Work Order Created])
  VAR __AllCount = COUNTROWS(ALL('Table'))
  VAR __CurrentCount = COUNTROWS(FILTER(ALL('Table'),[Date Work Order Created] <> BLANK() && [Date Work Order Created] <= __Date))
RETURN
  DIVIDE(__CurrentCount, __AllCount, 0)