Forum Discussion
How to exclude certain row values in dax measure?
Hi,
I need to make a measure that includes all rows in a specific column except 2 specific rows or names.
formula:
LTD Revenue Index vs Budget = CALCULATE(DIVIDE([LTD Rev. Acc. without blanks],[LTD Budget without blanks],BLANK())*100,
this below dont work:
ALLEXCEPT('Append table','Append table'[Country]="Canada", "Brazil"))
- TestMeasure = CALCULATE(SUM('Table1'[Sales Actual]), Table1[Country] <> "Canada" , Table1[Country] <> "Brazil")is one way to do it.
5 Replies
- affan
Solution Sage
Hi Anonymous
Can you please share some data
Regards
Affan
Table1 Country Sales Actual Sales Budget Denmark 150 154 Canada 139 83 USA 200 165 Brazil 30 40 France 80 90 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....
- HotChilli
Community Champion
TestMeasure = CALCULATE(SUM('Table1'[Sales Actual]), Table1[Country] <> "Canada" , Table1[Country] <> "Brazil")is one way to do it.
