Solved: Count based on condition - Page 2

tejapowerbi123 · ‎08-15-2020

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(

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

''Raw Data''[organization])

harshnathani · ‎08-15-2020

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!

Count based on condition