Dynamic Segmentation Help

ariana_night — Mon, 19 Sep 2022 17:50:53 GMT

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!

Re: Dynamic Segmentation Help

amitchandak — Tue, 20 Sep 2022 02:53:28 GMT

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/1387187#M626

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

topic Re: Dynamic Segmentation Help in DAX Commands and Tips

Dynamic Segmentation Help

Re: Dynamic Segmentation Help