Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a table like shown below, I dont want to display rows when Regional Total Orders = 0 and Customer Total Orders > 0, but all other rows should be displayed. Could someone please help ? I tried the IF(AND(COND1, COND2), "True", "False) but I'm running into issues.
Customer | Department | Region | Orders | Regional Total Orders | Customer Total Orders | |
A Corp | Sales | Asia | 0 | 2 | 7 | Don’t Display this Row |
A Corp | Marketing | Asia | 2 | 2 | 7 | Display this Row |
A Corp | R&D | Europe | 5 | 5 | 7 | Display this Row |
B Corp | Sales | Americas | 0 | 0 | 0 | Display this Row |
B Corp | Procurement | Americas | 0 | 0 | 0 | Display this Row |
B Corp | Research | Europe | 0 | 0 | 0 | Display this Row |
C Corp | Sales | Americas | 0 | 0 | 24 | Don’t Display this Row |
C Corp | Marketing | Americas | 0 | 0 | 24 | Don’t Display this Row |
C Corp | HR | Asia | 10 | 24 | 24 | Display this Row |
C Corp | Finance | Asia | 14 | 24 | 24 | Display this Row |
Solved! Go to Solution.
Why should your first row be excluded? Regional Total Orders for A Corp Sales Asia is not 0.
Why should your first row be excluded? Regional Total Orders for A Corp Sales Asia is not 0.
Thank you so much, yes the description was incorrect about the first row, but the solution worked perfect.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |