Measure showing wrong values

[rp2022]

 Data:

Date	Group	Reg	Plt	Mat	$	Qty
11/1/2023	PDC	K	u1	m1	1	9
12/2/2023	PDC	N	u2	m2	3	5
2/2/2024	PD	N	u3	m3	4	6
3/3/2024	PD	N	u4	m4	5	8
4/4/2024	PD	K	u1	m1	6	7
5/5/2024	Date	N	u2	m2	8	1
6/4/2024	Date	K	u5	m5	9	4
7/5/2024	Date	N	u4	m4	7	2
8/9/2024	Date	K	u7	m7	2	3

Measure: 

Value $ =

    VAR __group = MAX('Data'[Group])

    VAR __cur_date = MAX('Data'[Date])

    VAR __result = CALCULATE(SUM($),FILTER(ALLSELECTED('Data'),'Data'[Date]<=__cur_date  && 'Data'[Group] = __group))

RETURN __result

Correct Output:

When i use any visual, and just have Date and Value $, everything is okay and works as it should. Once i bring in any other detail into the visual, the numbers are all wrong.

Wrong Output:

Any help is appreciated.

[lbendlin · Accepted solution]

You can use SUMMARIZE to adjust to potential other filters.  But that still means you need separate measures.

Value $ = 
VAR b =
    ADDCOLUMNS (
        SUMMARIZE ( Data, [Date Label],[Reg] ),
        "md", CALCULATE ( MAX ( Data[Date] ) )
    )
VAR c =
    ADDCOLUMNS (
        b,
        "s",
            IF (
                [Date Label] IN { "PD", "PDC" },
                CALCULATE ( SUM ( Data[$] ) ),
                VAR md = [md]
                var r = [Reg]
                RETURN
                    CALCULATE (
                        SUM ( Data[$] ),
                        ALL ( Data ),
                        Data[Date] <= md,
                        Data[Reg] = r,
                        Data[Group] = "Date"
                    )
            )
    )
RETURN
    IF ( HASONEVALUE ( Data[Date Label] ), SUMX ( c, [s] ), SUMX ( Data, [$] ) )