Boolean calculations and filters

[Clint]

Hello,

I have a table of financial data that includes columns for statue (green, invoiced, at risk) and probability.  I need to be able to sum up entries that have both a Probability of 70% or higher and are green.  I've tried the following but I'm just not using "AND" right according to BI.  Any ideas on how to get this expression to work correctly?

CALCULATE(

    SUM('SYSTEMS FINANCIAL DATA'[Revenue]),

    'SYSTEMS FINANCIAL DATA'[Status] IN { "Grn" } AND,FILTER('SYSTEMS FINANCIAL DATA'[Prob/Inv]>=.7)

[parry2k]

@Clint  here it is

CALCULATE(
    SUM('SYSTEMS FINANCIAL DATA'[Revenue]),
    'SYSTEMS FINANCIAL DATA'[Status] IN { "Grn" } && 'SYSTEMS FINANCIAL DATA'[Prob/Inv]>=.7)

[Clint]

Thank you but I get the error msg "The expression contains multiple colulmns but only a single column can be used in a True/False expression that is used as a table filter expression. (this after replacing what I had w/your expression to be sure I didn't leave any errata in the expression)

[parry2k]

@Clint interesting. can you share few rows of sample data?

[parry2k · Accepted solution]

@Clint my apologies, see correct expression below

CALCULATE(
    SUM('SYSTEMS FINANCIAL DATA'[Revenue]),
    'SYSTEMS FINANCIAL DATA'[Status] IN { "Grn" }, 'SYSTEMS FINANCIAL DATA'[Prob/Inv]>=.7)

[Clint]

Perfect.  Thank you!