Table with records >= threshold and the rest with variable liine

[JVDW_VSH]

I have a table with debtors and a simple measure that calculates the open amount.

I would like to have a matrix that shows the debtors for which the total open amount is >= [a variable number] based on a numeric parameter and then have an additional row that reads "Others (< [variable number] )".

Let's say my data looks like this:

Debtor	Amount open
org A	50
org B	110
org C	30
org A	60
org D	99
org E	5

For which I have created a numeric parameter which I can slide between 0 and 200. Let's say I pick the number 100 here.
I would like to show the result as:

Debtor	Amount open
org A	110
org B	110
Others (< 100)	134
Total	354

If I change the numeric parameter to 50, I would like to show the result as:

Debtor	Amount open
org A	110
org B	110
org D	99
Others (< 50)	35
Total	354

I have created a calculated table where I summarize the debtors (key and name) and union this with an additional ROW with a dummy key and the name "Others (< " & 

SELECTEDVALUE('Parameter'[Parameter]) & ")". 
The right debtors and Ohters row are shown, but I somehow can't get the selected variable in there.

Is a calculated table the right solution? (if so, why doesn't this selected value not work? if not, what would be a better approach?)

[danextian · Accepted solution]

Hi @JVDW_VSH 

Calculated tables update only upon creation or when the underlying or referenced tables have been modified. SELECTEDVALUE('external table'[column]) returns blank within the context of a calculated table as it is not aware of any slicer selections.  You will need to create a disconnected table that has all the debtor names and all other Other (< 50,100..) rows

and then use a measure that references this table.

Open Amount Grouped = 
VAR _summary =
    ADDCOLUMNS (
        SUMMARIZECOLUMNS ( Debtors[Debtor Name], "@value", [Open Amount] ),
        "@group",
            IF (
                [@value] >= [Open Amount Value],
                [Debtor Name],
                FORMAT ( [Open Amount Value], "0" )
            )
    )
VAR _filtered =
    FILTER ( _summary, [@group] IN VALUES ( 'Debtors with Others'[Group] ) )
VAR _result =
    SUMX ( _filtered, [@value] )
RETURN
    _result

Please see the attached sample pbix.

[bhanu_gautam]

@JVDW_VSH , Can you share DAX of calculated table