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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.