I need to make a measure that includes all rows in a specific column except 2 specific rows or names.
Solved! Go to Solution.
|Country||Sales Actual||Sales Budget|
Could be something like this.
Then if i sum this i get 599 in sales actual and sales budget 532
but if i want to sum this in a measure while filtering out Brazil and Canada, how can i do this?
it has to be in a dax measure and not using the report, page or visual filter pane.
Sales Actual = Calculate(sum(table1,Sales Actual), FILTER.... exclude Brazil and Canada....