Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ariana_night
Frequent Visitor

Dynamic Segmentation Help

Hi there,

 

I am trying to build a matrix that shows Excess Stock categorized by Unit Groups and Excess Source but the Excess Stock needs to be filtered by LTD Gross Sales. See images for reference.

For example, we need to see how much excess stock lives in First Print and has had LTD Gross Sales between 5k-25k. I need to create a new measure for excess stock that is filtered by LTD Gross Sales. (see further explanation below)

ariana_night_0-1663609290101.png         ariana_night_1-1663609303499.png

 

 

I've tried using something like these 2 examples but I am struggling. (see images below)

 

ariana_night_2-1663609433857.pngariana_night_3-1663609447138.png

 

 

This is the breakdown of what fields I am using and relationships:

'Excess Inventory' [Excess Source] - is a column

'Excess Inventory' [Excess Stock] - is a measure

'LTD Billings' [LTD Gross Sales] - is a measure

'Author Thresholds' [Unit Groups] - is a column

 

There is no relationship between between these tables. Author Thresholds is a disconnected table being used only for the categorization. 'Excess Inventory' and 'LTD Billings' have no relationship but both have a relationship with the 'Product Hierarchy' table. 

Note: I am connected to a live data model therefore I can only create measures. 

 

I hope I've given enough information. Please let me know if I need to explain in more detail. Thank you for any feedback!

 

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@ariana_night , refer if my examples can help

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

 

 

Here there is equal to join, but use of table is better

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@ariana_night , refer if my examples can help

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

 

 

Here there is equal to join, but use of table is better

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.