Forum Discussion
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 ...
[Active Project Count] = COUNTROWS( FILTER( DISTINCT( T[Project] ), ISEMPTY( CALCULATETABLE( T, KEEPFILTERS( T[Status] in { "not started", "completed" } ) ) ) ) )
When I try to do this DAX command again, I am getting a return with blank rows? Any help?
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 🙂