The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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
Solved! Go to Solution.
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" ) )
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
User | Count |
---|---|
160 | |
110 | |
96 | |
86 | |
75 |
User | Count |
---|---|
157 | |
137 | |
132 | |
81 | |
61 |