Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I'm having a strange problem on this column formula. I have to put a flag based on 2 conditions. I wrote this formula:
Solved! Go to Solution.
Hi @Anonymous ! Why are you using SUM in formula?
Could you try:
Hi @Anonymous ! Why are you using SUM in formula?
Could you try:
Hi technolog,
The issue was exactly what you mentioned. I used incorrectly the sum formula so it was not calculating row by row, but in a table context.
Thank you for the immediate answer
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
10 | |
8 |