Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a table of 50 accounts & their products. These accounts buy products from distributors & sell to end customers. i have to create a dashboard which products are selling good & whatnot.
Solved! Go to Solution.
@mohan_g_das1986
Replace Column with this measure:
Ratio_units =
DIVIDE(
MAX('Table'[Sales Out]),
MAX('Table'[From Disty])
)
Modified Measure:
Measure =
VAR R = [Ratio_units]
VAR BRACKET_MAX = SELECTEDVALUE('Ration Bracket'[Max])
VAR BRACKET_MIN = SELECTEDVALUE('Ration Bracket'[Min])
RETURN
IF(
ISFILTERED('Ration Bracket'[Slab]),
IF(
R>=BRACKET_MIN &&
R<BRACKET_MAX,
1,
0
),
1
)
Ration Bracket Table:
Slab | Sort | Min | Max |
-41% -1000% | 1 | -0.41 | -10 |
-21% -040% | 2 | -0.21 | -0.4 |
00% -020% | 3 | 0 | -0.2 |
+00% 020% | 4 | 0 | 0.2 |
+21% +040% | 5 | 0.21 | 0.4 |
+41% +1000% | 6 | 0.41 | 10 |
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@mohan_g_das1986 , see if these can help
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
Can you share a screenshot of your Slicer showing all values? the brackets aren't clear enough.
Also, Insert a Table visual and drop Product and other fields that you need.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@mohan_g_das1986
Please check this file: https://1drv.ms/u/s!AmoScH5srsIYgYFgiIhao7Pl4_yk6w?e=ADQL32
Mark this reply as a solution if I answered your question
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi, Thanks for the workaround; guess we are almost there. Ratio units (is a measure), but you have made it as a column.
can you create a measure Ratio_units= Divide(Sales out, From Disty). Then see if this works.
Need your help, please
Hi @mohan_g_das1986 ,
var r = Out Ratio -- measure you have created for Ratio
Just put the measure name and it should work.
Also in measure 2 replace the Table[Col Name] with the Measure created for ratio. It will filter and give you the same results.
Regards,
HN
@mohan_g_das1986
Replace Column with this measure:
Ratio_units =
DIVIDE(
MAX('Table'[Sales Out]),
MAX('Table'[From Disty])
)
Modified Measure:
Measure =
VAR R = [Ratio_units]
VAR BRACKET_MAX = SELECTEDVALUE('Ration Bracket'[Max])
VAR BRACKET_MIN = SELECTEDVALUE('Ration Bracket'[Min])
RETURN
IF(
ISFILTERED('Ration Bracket'[Slab]),
IF(
R>=BRACKET_MIN &&
R<BRACKET_MAX,
1,
0
),
1
)
Ration Bracket Table:
Slab | Sort | Min | Max |
-41% -1000% | 1 | -0.41 | -10 |
-21% -040% | 2 | -0.21 | -0.4 |
00% -020% | 3 | 0 | -0.2 |
+00% 020% | 4 | 0 | 0.2 |
+21% +040% | 5 | 0.21 | 0.4 |
+41% +1000% | 6 | 0.41 | 10 |
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi - Thanks so much for this solution has worked. Appreciate you help
You are welcome!
If you are satisfied with my answer, please mark it as a solution so others can easily find it.
APPRECIATE KUDOS!
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
This is how the data is in my table; Ratio is a measure (Salesout/From Dity)-1.
I want to create a filter checklist / Slicer button - using the ratio value. (0 to 20%) - 1 choice, (21% to 40%) 2nd choice & 3rd >=41%. Similarly 0 to -20, -21 to -40 & < -41%.
Based on the selection I wanted the user to see their data (Reseller_Name, product & units)
ID | Month | Reseller_Name | Product | From Disty | Sales Out | Ratio (Measure created) |
3-H-3899 | May | Reseller_Name1 | Product1 | 900 | ||
3-G-3900 | May | Reseller_Name2 | Product2 | 100 | ||
3-H-3900 | May | Reseller_Name3 | Product3 | 500 | 10 | -98% |
3-G-3901 | May | Reseller_Name4 | Product4 | 1700 | 300 | -82% |
3-H-3901 | May | Reseller_Name5 | Product4 | 900 | 1100 | 22% |
3-G-3902 | May | Reseller_Name6 | Product6 | 856 | ||
3-H-3902 | May | Reseller_Name7 | Product1 | 5000 | 80 | -98% |
3-G-3903 | May | Reseller_Name8 | Product2 | 3400 | 3000 | -12% |
3-H-3903 | May | Reseller_Name9 | Product5 | 300 | 159 | -47% |
3-H-3900 | May | Reseller_Name3 | Product1 | 5000 | 10 | -100% |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
76 | |
74 | |
56 | |
45 |
User | Count |
---|---|
117 | |
105 | |
77 | |
66 | |
64 |