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 ...

Get Microsoft Power BI Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.