Forum Discussion
Apply two rows filter
Measure:
AverageSales = Calculate([Your Average Calculation], Filter([Your Table], Country = "USA" || Country = "India")
New Table
Option1:
Look at this post by v-jiascu-msft to create a summaryized table
Option 2:
Or from Power Query you could always create a reference to your original table and filter out data not related to USA or India. This would leave you with just the data your loking for.
Hi nrungta ,
You could create a new table with CALCULATETABLE() function.
Table 2 = CALCULATETABLE ( test, FILTER ( test, test[country] = "India" || test[country] = "US" ) )
Measure:
AverageSales = Calculate([Your Average Calculation], Filter([Your Table], Country = "USA" || Country = "India")
New Table
Option1:
Look at this post by v-jiascu-msft to create a summaryized table
Option 2:
Or from Power Query you could always create a reference to your original table and filter out data not related to USA or India. This would leave you with just the data your loking for.
After applying these two row filters of USA and India. Can I apply more filters of another column (Zone) and filter further to 'South' and 'North'
Anonymous v-eachen-msft