Forum Discussion

tejapowerbi123's avatar
tejapowerbi123
Helper V
6 years ago
Solved

Count based on condition

Hi Community, Please review below and provide your suggestion, I want to count organization based on “Decision”, I have used below formula and it not showing right result. Count = COUNTX(     FI...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI tejapowerbi123 ,

     

    Create a Calculated Column

     

    Column = CALCULATE(COUNT(Table2[Decision]),FILTER( ALLEXCEPT(Table2,Table2[Organization]), Table2[Decision] = "Award"))

     

     

     

    Regards,
    Harsh Nathani

    Appreciate with a Kudos!! (Click the Thumbs Up Button)
    Did I answer your question? Mark my post as a solution!

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi tejapowerbi123 

 

I would use

 

_Count = 

CALCULATE(COUNTX('Raw Data'[organization]), ALLEXCEPT('Raw Data','Raw Data[Decision]))

(OR)

CALCULATE(COUNTROWS('Raw Data'),'Raw Data'[Decision]="Award")

 

Did I resolve your issue? Mark my post as a solution!

 

Appreciate your Kudos, Press the thumbs up button!!

 

Regards,
Pranit

  • tejapowerbi123's avatar
    tejapowerbi123
    Helper V
    6 years ago

    Thank you so much Pranit, I have used your suggestion but result is still not right.

    Count only based on Awarded
    2411
    2411
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi tejapowerbi123 

     

    I believe what you are looking for is below:

     

    CALCULATE (
    COUNTROWS('Raw Data'),
    FILTER ( ALLEXCEPT('Raw Data','Raw Data'[Decision]),'Raw Data'[Decision]="Award")
    )

     

    Did I resolve your issue? Mark my post as a solution!

     

    Appreciate your Kudos, Press the thumbs up button!!

     

    Regards,
    Pranit