Forum Discussion
Rows exclusion based on 2 columns
Solution SageHi Heleo
Same way you explained, you need to filter two times. You can try in power query:
Hope it helps.
Thank you for your answer, the thing is that I don't want to have to write all the company names myself to exclude them. I would like them to be retrieved and excluded automatically. In my example, I only have one value but in real life, I have thousands. 🙂
- mahenkj2
Hi Heleo ,
To work efficiently in power bi or any such reporting tool, I would recommend using best practices. One of the key thing related to your application is, using star schema or dimension and fact tables. The attributes shown in the sample data you showed is kind of dimensions and should be used as a slicer or filter. I am sure in your real data, you would have several other columns, which will carry mostly numeric values or some other attributes. That should work as fact tables and then you create relationships between dimension and fact tables.
If you are a new user, it might be difficult for you to quickly grasp what I said above and my expalnation not might be so succint, but it should give you a direction to start with.
Just look at some snapshots I wish you could check:
Then your report might be like this:
There are further to this to learn about design considerations for star schema and I dont want to overwhelm for this question.
Hope it helps.