Forum Discussion

lea_313's avatar
lea_313
Icon for Helper I rankHelper I
4 years ago
Solved

Count based on multiple criteria

Hiya   I need to calculate some counts but its proving a bit tricky   Sample data below   Project code ID Product for Month Year Revenue Product Header Stage 1544 Class 1 January ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    lea_313 , so you actually do want to count up the number of [Project code ID] that are active? Then I think this measure will work:

    Active Project Count = 
    SUMX(
        VALUES('lea_313'[Project code ID])
        ,MAXX('lea_313', IF(FIND("100%", 'lea_313'[Stage], 1, 0) = 0, 1, 0))
    )
lea_313's avatar
lea_313
Icon for Helper I rankHelper I
4 years ago

Hiya

 

Thanks for your help

 

I've added the measure. I get a Y/N rather than a count of active projects by project code. How do I convert this to a count please?

 

For example, there are 10 active Coaching, 5 active team in 2022

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
4 years ago

lea_313 , so you actually do want to count up the number of [Project code ID] that are active? Then I think this measure will work:

Active Project Count = 
    SUMX(
        VALUES('lea_313'[Project code ID])
        ,MAXX('lea_313', IF(FIND("100%", 'lea_313'[Stage], 1, 0) = 0, 1, 0))
    )