Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Cumulative Distinct Count and Slicer

Hello,   I am running circles with this:   Need to do a cumulative distinc count  ( task ) So that I can play two cumulative line charts.   Line A - Cumulative Task by start date ( started task...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi Anonymous

     

    I think these calculated measures might be close...

     

    Cumulative Task by Start Date = 
			CALCULATE(
				DISTINCTCOUNT('Table1'[Task]),
				FILTER(
						ALLSELECTED('Table1'),
						'Table1'[Start date]<=MAX('Dates'[Date])
						)
						)

    and

     

    Cumulative Task by Finish Date = 
			CALCULATE(
				DISTINCTCOUNT('Table1'[Task]),
				FILTER(
						ALLSELECTED('Table1'),
						'Table1'[Finish Date]<=MAX('Dates'[Date])
						)
						)

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous

 

I think these calculated measures might be close...

 

Cumulative Task by Start Date = 
			CALCULATE(
				DISTINCTCOUNT('Table1'[Task]),
				FILTER(
						ALLSELECTED('Table1'),
						'Table1'[Start date]<=MAX('Dates'[Date])
						)
						)

and

 

Cumulative Task by Finish Date = 
			CALCULATE(
				DISTINCTCOUNT('Table1'[Task]),
				FILTER(
						ALLSELECTED('Table1'),
						'Table1'[Finish Date]<=MAX('Dates'[Date])
						)
						)

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Great! I were failing on the allselect filter...

Now I got the cumulative lines!