Forum Discussion

PoorBIGuy's avatar
PoorBIGuy
Frequent Visitor
2 years ago
Solved

Quick question about the CALCULATE function

I have a customer sales table like this:   I am trying to calculate total sales by customer for year 1 and year 2, and wish to have an IF formula to determine "large" or "small" based on year...
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    PoorBIGuy So this?

    Measure = 
  VAR __Sales = CALCULATE(SUM(),ALLEXCEPT(Customer))
  VAR __Result = IF( __Sales > 80, "Large", "Small" )
RETURN
  __Result
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

PoorBIGuy So this?

Measure = 
  VAR __Sales = CALCULATE(SUM(),ALLEXCEPT(Customer))
  VAR __Result = IF( __Sales > 80, "Large", "Small" )
RETURN
  __Result