Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |