Fine value (Point) from data range

[Anonymous]

Hi, 

I have seperate tables (and they are not related).

One table called "Order_Tbl" listing customer with delivery date against due date.

The other called "OT_Range" listing performace range based on Ontime percentage. 

Now I would like to add "Point" column to below table

For example, with OT_Percentage 50%, it should bring "30 points according to OT_Range.

Can someone help me as to how I can do so?

[Anonymous]

By the way, if I would like to count and present how many of point "A", "B" and "C" are in total from measured table, how can I calculate?

With example below, we should see 2 x "A" and 1 x "B". 

[FreemanZ]

hi @Anonymous 
That depends on many things. Try to plot card visuals with the two measure below:
CountA :=
VAR _table =
ADDCOLUMNS(
VALUES(Order_Tbl[Customer]),
"Points",
[Point]
)
RETURN
COUNTROWS(FILTER(_table, [Points]="A")

CountB :=
VAR _table =
ADDCOLUMNS(
VALUES(Order_Tbl[Customer]),
"Points",
[Point]
)
RETURN
COUNTROWS(FILTER(_table, [Points]="B")
p.s. please consider @me if you seek further suggestion, otherwise i may lose the thread.

[Anonymous]

Thank you

[FreemanZ · Accepted solution]

hi  @Anonymous

try to plot as well a measure like this:

Point = 

VAR _pct = [OT_Percentage]

RETURN

MINX(

    FILTER(

        OT_Range,

        _pct>=OT_Range[MinValue]

            &&_pct<OT_Range[MaxValue]

    ),

    OT_Range[Points]

)