Forum Discussion

Qualube's avatar
Qualube
Helper II
8 years ago
Solved

IF statement

Hi   I would like to determine if a particular customer has been active in the last quarter. I have all sales in a column called difference but can't seem to find the right IF statement to return t...
Need Help
  • Qualube's avatar
    Qualube
    7 years ago

    Managed to solve it after looking extensively on the web with a new measure:

     

    InactiveCustomers = CALCULATE( COUNTROWS( 'Customer List Table' ), FILTER( ALL('Customer List Table'[Difference]), 'Customer List Table'[Difference] <= 0 ))

     

    Thanks for the help anyway

Qualube's avatar
Qualube
Helper II
8 years ago

Hi T

 

The problem is I get this error message:

 

 

 

Caitlin_Knox's avatar
Caitlin_Knox
Advocate III
8 years ago

Is Difference a calculated column or a measure?

  • Qualube's avatar
    Qualube
    Helper II
    8 years ago

    Hi Caitlin

     

    It's a measure as what I need to do is filter through the [difference] column and return the number of customers with zero or negative sales over a quarter.

    I have looked extensively and I think SUMX is the expression I need to use but I can't make it work.

     

    Thanks