Forum Discussion
Apply two rows filter
My data has a column Country. I have data points of 10 countires in the Country Column. Now I want to use average Sales of only two countries, USA and India.
1. How can I use this in a Measure?
2. How can I make a new table from it?
Thanks in Advance
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" ) )
3 Replies
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
Hi nrungta ,
You could create a new table with CALCULATETABLE() function.
Table 2 = CALCULATETABLE ( test, FILTER ( test, test[country] = "India" || test[country] = "US" ) )
