Forum Discussion
mohan_g_das1986
Helper III
6 years agoCreate Segments for measure which is in %
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. TotalS...
- 6 years ago
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
Fowmy
Super User
6 years agomohan_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 |
mohan_g_das1986
Helper III
6 years agoHi - Thanks so much for this solution has worked. Appreciate you help
- Fowmy6 years ago
Super User
You are welcome!
If you are satisfied with my answer, please mark it as a solution so others can easily find it.
APPRECIATE KUDOS!