Forum Discussion
Virtual Table Row Count with Boolean Expression
That worked with the help of an if statement in my virtual column to create the boolean output to sum.
Thanks!
COUNTX won't work with boolean condition. Boolean condition will return either one or zero and CONTX will count booth.
As you've already mentioned in your post, SUMX will provide perfecr count of "1".
Thanks for the quick response. Do you have any suggestions on how to count the number of rows of the virtual table that meet the conditions specified? I don't want the sum of the values from the expression i want to be able to compare each value to a criteria (in this case '1') and return a count of only those rows that meet the requirement. Do you know of a better strategy?
Thanks,
Sean
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.