i I have a report where i need the following not to be shown.
Background
Under BIlling I have 4 options Booking , Corporate , Portal sales , Reception sales and under Ship ID i have various ships 6 , 5 , 26 etc etc
What I need
I want to the report to show me billing type is not corporate and under the following ships IDs 6, 35,28, 32, 42 , 5 or 62. When i use the page filter option as shown in the image below . the Ship IDs mentioned aboved is also removed from the report but what i need is only for the CORPORATE to be removed from those ships IDs.
Should I use a SUMIF or IF formula ? Not sure how to go about it
Can someone please help me with this
@Anonymous not sure I understood your request correctly. If you filtered on corporate why you are also filtering on "ship id". Did you tried using not to filter "ship id"
as best practice please share sample data and expected result to get your answer quickly.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous not sure I understood your request correctly. If you filtered on corporate why you are also filtering on "ship id". Did you tried using not to filter "ship id"
as best practice please share sample data and expected result to get your answer quickly.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi Parry @parry2k
Well my question is I want to know how to get a report which shows all data that is not billing type "coroporate" under the following ships ids of 6, 35,28, 32, 42 , 5 or 62.
Because under these ships there are other billing types such as portal sales, reception and booking which I need the data to be visible.
Hope I am a bit clear now
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
