DAX COUNTA with TRUE/FALSE Condition

[swright0409]

Hello Community,

I am having an issue with a COUNTA forumala..I successsfully have as follows:

Created Quotes =

     CALCULATE(

          COUNTA(quotes[_createdby_value]),

          FILTER(

               ALL(quotes),

               quotes[_createdby_value] =

               'Quotes Model'[systemusers]))

I need basically recreate this, but limit the count to whether or not a column in the quotes table is "False". So something similar to the below:

Created Quotes w/ Opportunity =

     CALCULATE(

          COUNTA( quotes[_createdby_value] ),

          FILTER( quotes, [Opportunity T/F] = FALSE() ))

               quotes[_createdby_value] =

               'Quotes Model'[systemusers]))

)

Any idea on how to get

[swright0409 · Accepted solution]

Incase anybody finds this and it can help them, I was originally thinking about this backwards.

Proper DAX that worked for me is as follows:

Created Quotes w/ Opportunity =

CALCULATE(

COUNTA( quotes[Opportunity T/F] ),

FILTER( quotes, quotes[Opportunity T/F] = FALSE() &&

quotes[_createdby_value] = 'Quotes Model'[systemusers])

)