Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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
@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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |