1. When a new Tabular fact table is created, all numeric columns that are market as additive (apart from key columns) will have auto-created measure totals. 
  2. If the created columns are not relevant for the table, they can be deleted by using the right-click option to Delete Column.
  3. To add new measures to your Tabular Fact table, right-click on a column in the middle pane and click Add Column. In the table column properties you can set the following fields:
    • Column name: "measure_sales_total"
    • Business Display Name: "Sales Total"
    • Type: Measure
  4. Click the Transformation tab, add SUM to the Column  Transformation Code and then select a sales column from the list. Click OK.
  5. Right click the table fact_order_detail_tabular from the left pane and then select Create(Recreate).
  6. After the table has been recreated, right click again and then select Update to update the table.
  • No labels