Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
17 | |
14 | |
13 | |
13 | |
12 |
User | Count |
---|---|
19 | |
15 | |
14 | |
10 | |
9 |