Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
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
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |