cancel
Showing results for
Did you mean:
Member

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:

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

Re: How to exclude certain row values in dax measure?

TestMeasure = CALCULATE(SUM('Table1'[Sales Actual]), Table1[Country] <> "Canada" , Table1[Country] <> "Brazil")

is one way to do it.
3 REPLIES 3
Established Member

Re: How to exclude certain row values in dax measure?

Hi @Fazniro

Can you please share some data

Regards

Affan

Member

Re: How to exclude certain row values in dax measure?

 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....

Established Member

Re: How to exclude certain row values in dax measure?

TestMeasure = CALCULATE(SUM('Table1'[Sales Actual]), Table1[Country] <> "Canada" , Table1[Country] <> "Brazil")

is one way to do it.