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
[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

For some reason I am not getting the correct answer using this code above.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    That's not informative enough. What precisely is wrong and what you expect? This is the info you have to supply for me to be able to troubleshoot.