Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help needed with DAX

So i have a data table with different project submitting weekly status report. I want to count active projects (which is anything other than not-started, and completed) and display this measure on a ...
  • Anonymous's avatar
    Anonymous
    5 years ago
    [Active Project Count] =
COUNTROWS(
	FILTER(
		DISTINCT( T[Project] ),
		ISEMPTY(
			CALCULATETABLE(
				T,
				KEEPFILTERS(
					T[Status] in {
						"not started",
						"completed"
					}
				)
			)
		)
	)
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

 

It would be great if you could mark my answer as THE answer (so that this helps others) and I would also appreciate kudos (thumbs-up). Thanks.