So building on the example from the aforementioned thread. First thing we need to do is make a better data model. I created a few dimension tables and related as such:
Now we have a solid data model, we can start with the DAX. For this example I’ll stick with Total Sales Transactions. Always create the measures, no matter how easy it is.
Total Sales Transactions = SUM( 'Fact'[Sales Transactions] )
Keeping that in mind we can write the following measure for only sales that are not “SIS”
But what if we wanted to still to see the Full Price or Outlet total, and not the total of those two?
Here is the pbix file along with the data file if you want to see what I did to create the data model. There’s a parameter in PQ to change the file so be sure to change that
data.csv (671 Bytes)
Keep Filters.pbix (45.4 KB)