Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |