Adding a Count Field to Table
When your data has more than 10000 rows, adding the field Season as Count to the Table is inefficient because Power View must do the computation every time you alter the layout of the Table. Adding a computed field to the Season data table in the Data Model is a more effective method.
Step 1: On the Ribbon, select the PowerPivot tab. In the Data Model group, choose Manage. The Data Model’s tables will be presented.
Select-Data-Model
Step 2: Select the Results tab. In the Results table, in the calculation area, in the cell below the Season column, enter the DAX (Data Analysis Expressions) formula shown below:
Season Count: =COUNTA([Season])
The Season count formula is shown in the formula bar. When you Hover your mouse over a Season, then it will show the Season Count i.e.,16 in this case.
COUNTA Function
Step 3: Again, you will get a Power View notification indicating that the Data Model has been altered, and if you click OK, the changes will be reflected in your Power View. Select OK.
Power-View
Step 4: You may see the following in the Power View Fields list. Season Count is a new field added to the Range table. Season Count has a calculator icon next to it, suggesting that it is a calculated field. Choose the following options: Country, Events, Season, Season Count, and Year. Your Power View Table shows the Season count by Season wise.
Table Visualization in Excel Power View
For whatever visualization we decide to make with Power View, we start by generating a Table, which is the default, and then quickly convert the Table to other visualizations.
The Table is formatted similarly to any other data table, with columns representing fields and rows representing data values. To pick which fields to display in the Table, use the Power View Fields list to select and deselect fields. Fields from the same data table or multiple related data tables might be used.
Contact Us