Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I'm trying to create regions from a group of cities - for example, the Dallas-Fort Worth region is comprised of ~200 cities. What is the best approach to accomplish?
Thank you so much!
~AGS
Solved! Go to Solution.
You could bring in a table with city and state columns and merge that into your data. Or you could make a Groups column yourself.
Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @AaronGlenn10 ,
If you already have a group column, you could use ALLEXCEPT() function to get the average for each group.
https://docs.microsoft.com/en-us/dax/allexcept-function-dax
For example:
average = calculate(average('table'[value]),allexcept('table'[group]))
Best Regards,
Jay
Hi @AaronGlenn10 ,
If you already have a group column, you could use ALLEXCEPT() function to get the average for each group.
https://docs.microsoft.com/en-us/dax/allexcept-function-dax
For example:
average = calculate(average('table'[value]),allexcept('table'[group]))
Best Regards,
Jay
You could bring in a table with city and state columns and merge that into your data. Or you could make a Groups column yourself.
Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I've created a group but it doesn't work when I try to use as a visualization filter.
what will your group be based on? State? county?
Proud to be a Super User!
I'm only focused on one state - Texas. The regions [groups] will be based on cities. Need to create four regions - DFW, Austin, San Antonio, and Houston. The DFW region [group], for example, will have 200 cities.
Does that help?
as per @mahoneypat I would go with the grouing option.
Proud to be a Super User!
How would I calculate an average across this group:
Same Store TTM Delta % for ABILENE & ACTON & ADKINS & ALAMO & ALAMO HEIGHTS & ALBA =
CALCULATE(
[Same Store TTM Delta %],
'TABC'[location_city (groups) 2]
IN { "ABILENE & ACTON & ADKINS & ALAMO & ALAMO HEIGHTS & ALBA" }