Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dax Help Needed

So i have a data table with different project submitting weekly status report. I want to count number of ongoing active projects (which is anything other than not-started, and completed) and display ...
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

yes, that's possible. Check the following measure:

Projects Submitted =
CALCULATE(
    DISTINCTCOUNT( myTable[Projects] ),
    myTable[Status]
        IN {
        "On-Track",
        "at risk <1 Week behind",
        "serious risk >1 week behind"
    }
)

 

I didn't see a project id column, so I just did the DISTINCTCOUNT on the project name. I personally find it always a little dangerous to count on text. When 2 projects have the same name you will get wrong results. So I would prefer to count on unique Project IDs.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am not getting the right answer. Is it possible to just get a distinct count of the project that does not have not started or complete instead?