What should you do?

Your company has employees in 10 states.

The company recently decided to associate each state to one of the following three regions: East, West, and North.

You have a data model that contains employee information by state. The model does NOT include region

information.

You have a report that shows the employees by state.

You need to view the employees by region as quickly as possible.

What should you do?
A . Create a new aggregation that summarizes by employee.
B . Create a new group on the state column and set the Group type to List.
C . Create a new group on the state column and set the Group type to Bin.
D . Create a new aggregation that summarizes by state.

View Answer

Answer: B

Explanation:

https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/