Forum Discussion
Filtering OUT names from a separate table
Hi Anonymous ,
You can use EXCEPT function to do this.
https://www.youtube.com/watch?v=TL81opk59aE
Regards,
Harsh NathaniAppreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
It's hard for me to completely oversee, since the model is not known.
The disadvantage of filtering out this way is that it is all done by coding DAX, so you also need to change your other measures.
There are also techniques that use parameters to determine which rows to load into the datamodel. A change in a parameter causes the data to be loaded again, but then you can constrain the data by the value of the parameter. Never used it, and I don't know if it can help out, since loading data can take up quite an amount of time.
So i'm thinking, is there a way to build a new table from my master table but not include the group?
In Power Query you can create a copie of your table and the remove the column without the group. But I'm not sure if that is what you need though.