Show DAX calculations on Power BI Column asset pages

Data Analysis Expressions (DAX) is a programming language that is used in Power BI for creating calculated columns, measures and custom tables.

Power BI columns that are derived from DAX are shown in the technical lineage. However, the Collibra Data Lineage service instances are unable to parse DAX. Therefore, stitching between calculated columns in the technical lineage and the corresponding Power BI Column assets in Data Catalog is not possible.

You can, however, show DAX calculations for calculated columns and measures on Power BI Column asset pages. To do so, you only have to ensure that the Calculation Rule attribute type is part of the global assignment of the Power BI Column asset type.

Note All elements in the DAX, even comments for example, are included and shown in the Calculation Rule attribute.

The following additional information on Power BI Column asset pages can also help you interpret the lineage:

• If a calculated column is a measure, the Role in Report attribute has the value "Measure".
• The Technical Data Type attribute indicates the type of column, for example "String" or "Number".

Add the Calculation Rule attribute type to the global assignment

To show DAX calculations, the Calculation Rule attribute type must be part of the global assignment of the Power BI Column asset type. By default, it is not included.

Prerequisites

• You have a global role that has the System administration global permission.

Steps

1. Open the Power BI Column asset type.

   1. On the main toolbar, click , and then click Settings.
      The Collibra settings page opens.
   2. Click Operating Model.
      The operating model settings appear on the Asset types tab page.
   3. In the overview of asset types, click Power BI Column.
2. In the tab pane, click Global assignment.
   
   Tip If the Calculation Rule attribute type already exists in the table, you don't have to do anything more. However, as described in step 6, you might want to ensure that the Min. option is set to 1, so that the attribute type automatically appear on the asset page.
3. Above the table, to the right, click EditEdit Model.
4. Above the table, to the right, click Add characteristic.
   The Add a Characteristic dialog box appears.
5. Search for and click Calculation Rule.
   The Calculation Rule attribute type appears at the bottom of the table.
6. If required, edit the minimum or maximum number of occurrences of the characteristic.
   

   Option	Description
   Min.	The minimum number of occurrences of the characteristic. Tip Set this option to 1, to make the attribute type automatically appear on the asset page.
   Max.	The maximum number of occurrences that you can assign to an asset type. Leave this option empty if you don't want a limit to the maximum number of occurrences.

7. Above the table, to the right, click Save.

1. Open the Power BI Column asset type.

   1. On the main toolbar, click , and then click Settings.
      The Collibra settings page opens.
   2. Click Operating Model.
      The operating model settings appear on the Asset types tab page.
   3. In the overview of asset types, click Power BI Column.
2. In the tab pane, click Global assignment, and then click Characteristics.
   
   Tip If the Calculation Rule attribute type already exists in the table, you don't have to do anything more. However, as described in step 6, you might want to ensure that the Min. option is set to 1, so that the attribute type automatically appear on the asset page.
3. Above the table, to the right, click EditEdit Model.
4. Above the table, to the right, click Add a Characteristic.
   The Add a Characteristic dialog box appears.
5. Search for and click Calculation Rule.
   The Calculation Rule attribute type appears at the bottom of the table.
6. If required, edit the minimum or maximum number of occurrences of the characteristic.
   

   Option	Description
   Min.	The minimum number of occurrences of the characteristic. Tip Set this option to 1, to make the attribute type automatically appear on the asset page.
   Max.	The maximum number of occurrences that you can assign to an asset type. Leave this option empty if you don't want a limit to the maximum number of occurrences.

7. Above the table, to the right, click Save.