Regarding Running Total count.

[Link2mukesh]

Hi All,

 please suggest how show running in visual when prepared date are in one column and approved date are in another column, we need show running total on line chart both approved count and prepared count.

[Shahid12523]

Use this

Running Prepared =
CALCULATE(
COUNTROWS(FILTER(YourTable, NOT ISBLANK(YourTable[PreparedDate]))),
FILTER(ALL('DateTable'[Date]), 'DateTable'[Date] <= MAX('DateTable'[Date]))
)

Running Approved =
CALCULATE(
COUNTROWS(FILTER(YourTable, NOT ISBLANK(YourTable[ApprovedDate]))),
FILTER(ALL('DateTable'[Date]), 'DateTable'[Date] <= MAX('DateTable'[Date]))
)