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.
The data in the left side of the table is what i have, i want to remove "sections" that are "0", however there are "cat" with all "section" equals to "0", and i would like to keep this "cat" as shown in the right side of the table.
cat | section | T/F | cat | section | T/F | |
1 | A | 1 | 1 | A | 1 | |
1 | B | 0 | 2 | D | 1 | |
1 | C | 0 | 3 | null | null | |
1 | D | 0 | 4 | null | null | |
2 | A | 0 | 5 | null | null | |
2 | B | 0 | 6 | null | null | |
2 | C | 0 | 7 | any of the letter | 0 | |
2 | D | 1 | ||||
3 | null | null | ||||
4 | null | null | ||||
5 | null | null | ||||
6 | null | null | ||||
7 | A | 0 | ||||
7 | B | 0 | ||||
7 | C | 0 | ||||
7 | D | 0 |
Solved! Go to Solution.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
94 | |
50 | |
43 | |
40 | |
35 |