Microsoft Power BI Cookbook

Segmentation example

The goal of this example is to apply the following segmentation table to the measures of the data model:

Sales Growth Segmentation Table

A sample Power BI report based on the virtual relationship expressions could appear as follows:

Power BI Report Utilizing Segmentation Table and Virtual Relationships

• Three separate DAX measures are utilized for this example report:
  • A distinct count of customer countries and one for products, both filtered by the segmentation table
  • A sales growth tier metric that returns the text value ...