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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    When I try to do this DAX command again, I am getting a return with blank rows? Any help?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Without any info on/data about/knowledge of the environment where this happens? I'm very sorry but I can't give you any advice. I'm not a fortune-teller 🙂