Dynamic Segmentation Help

[ariana_night]

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)

         

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

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!

[amitchandak · Accepted solution]

@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