Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 84 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |