cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swright0409 Frequent Visitor
Frequent Visitor

DAX COUNTA with TRUE/FALSE Condition

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
 
1 ACCEPTED SOLUTION

Accepted Solutions
swright0409 Frequent Visitor
Frequent Visitor

Re: DAX COUNTA with TRUE/FALSE Condition

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])
)

View solution in original post

1 REPLY 1
swright0409 Frequent Visitor
Frequent Visitor

Re: DAX COUNTA with TRUE/FALSE Condition

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])
)

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors