Forum Discussion

klopdaddy's avatar
klopdaddy
Regular Visitor
4 years ago
Solved

Virtual Table Row Count with Boolean Expression

Hello- I am tryint to count the # of events by comparing two calculated measures and returning the count of only those rows that meet the condition. I've been trying via the DAX statement and creati...
  • klopdaddy's avatar
    klopdaddy
    4 years ago

    That worked with the help of an if statement in my virtual column to create the boolean output to sum.

    Thanks!

tamerj1's avatar
tamerj1
Community Champion
4 years ago

klopdaddy 

Just replace CONTX with SUMX to cout the trure condition. Boolean condition can be summed. The sum would be the count of true cases as true is translated to 1. 

klopdaddy's avatar
klopdaddy
Regular Visitor
4 years ago

That worked with the help of an if statement in my virtual column to create the boolean output to sum.

Thanks!

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    klopdaddy 

    If you find my reply helpful you may consider selecting it as acceptable solution. Thank you and have a great weekend!