Applying If statement to column after already aggregated in Table

[Anonymous]

Hi All,

  Hopefully I’m able to explain this situation clearly, I’m somewhat new.  I have a table like this

Product Code	Quarter	Searches
14753551	2019Q1	150
14753551	2019Q2	200
14753551	2019Q3	300
14753551	2019Q4	200
14754061	2019Q1	600
14754681	2019Q1	1100

I have a table in Power BI with Product Code and Sum of Searches as in the picture attached.  I want to apply an If statement AFTER it is already aggregated like the way it happens in an Excel pivot,  since the user can select whatever quarter(s) they want in a slicer. 

   So if the sum of seaches > 400 then should be  ‘yes!’.  But even if I try using calculate, Sumx, it is still considering the Quarter field in the if statement somehow.  The red box I highlighted should be yes!.   It is correct if I bring in the Quarter - see other picture.  Any ideas? Thank you!

[az38 · Accepted solution]

Hi @Anonymous 

try a measure

Measure = 
if(calculate(sum('Table'[Searches]);ALLEXCEPT('Table';'Table'[Quarter];'Table'[Product Code]))>400;"yes";"no")

do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin

[Anonymous]

Thanks so much!   I just had to change ";" to ","  and exactly what I needed and I would not have figured this out any time soon.  Thanks again

[az38]

@Anonymous the symbol-delimiter depends on system localization.

cheer and good luck! welcome to pbi family 🙂

do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin