Fix the the line and chart column chart tooltip

[Ohbenditesdonc]

In certain conditions, the tooltips seems to generate a cartesian product when you use the line and chart column tooltip.

Steps to reproduce the bug

• Generate a fact table

SampleData = 
VAR StartDate = DATE(2024, 12, 1)
VAR EndDate = DATE(2025, 3, 31)
VAR DateRange = DATEDIFF(StartDate, EndDate, DAY)

RETURN
UNION(
    SELECTCOLUMNS(
        GENERATESERIES(1, 500, 1), // This generates our 500 rows
        "Ticket Number", "D" & FORMAT(MOD([Value] - 1, 101), "000"), // "D000" to "D100" repeated

        // Calculate a consistent Creation Date based on the Ticket Number itself
        "Creation Date",
            VAR TicketIndex = MOD([Value] - 1, 101) // Gets the index 0-100 for the current ticket
            RETURN
                StartDate + MOD(TicketIndex, DateRange + 1) + (INT(TicketIndex / (DateRange + 1)) * RANDBETWEEN(0, 100)) / (24*60*60),
                // The above line calculates a fixed date for each TicketIndex, ensuring consistency

        "Last Actualisation Date",
            // Ensure Last Actualisation is after or equal to Creation Date
            // We need to recalculate the specific CreationDate for the current row's TicketNumber
            VAR CurrentTicketIndex = MOD([Value] - 1, 101)
            VAR CurrentTicketCreationDate = StartDate + MOD(CurrentTicketIndex, DateRange + 1) + (INT(CurrentTicketIndex / (DateRange + 1)) * RANDBETWEEN(0, 100)) / (24*60*60)
            RETURN
                CurrentTicketCreationDate
                + RANDBETWEEN(0, 90) // Add 0 to 90 days to creation date for last actualisation
                + RANDBETWEEN(0, 86399) / (24*60*60), // Add random seconds for time component
        "Status", "In Progress"
    ),
        SELECTCOLUMNS(
        GENERATESERIES(1, 100, 1), // This generates our 500 rows
        "Ticket Number", "D" & FORMAT([Value], "000"), // "D000" to "D100" repeated

        // Calculate a consistent Creation Date based on the Ticket Number itself
        "Creation Date",
            VAR TicketIndex = [Value]-1 // Gets the index 0-100 for the current ticket
            RETURN
                StartDate + MOD(TicketIndex, DateRange + 1) + (INT(TicketIndex / (DateRange + 1)) * RANDBETWEEN(200, 300)) / (24*60*60),
                // The above line calculates a fixed date for each TicketIndex, ensuring consistency

        "Last Actualisation Date",
            // Ensure Last Actualisation is after or equal to Creation Date
            // We need to recalculate the specific CreationDate for the current row's TicketNumber
            VAR CurrentTicketIndex = [Value]-1
            VAR CurrentTicketCreationDate = StartDate + MOD(CurrentTicketIndex, DateRange + 1) + (INT(CurrentTicketIndex / (DateRange + 1)) * RANDBETWEEN(200, 300)) / (24*60*60)
            RETURN
                CurrentTicketCreationDate
                + RANDBETWEEN(0, 90) // Add 0 to 90 days to creation date for last actualisation
                + RANDBETWEEN(0, 86399) / (24*60*60), // Add random seconds for time component
        "Status", "Closed"
    ))

• Create two measures

Row Count = COUNTROWS(SampleData)

Unique ticket = DISTINCTCOUNT(SampleData[Ticket Number])

• Create a line and chart column visual like this

X-Axis : Month from the hierarchy generated by default

Y-Axis : Row count

Column legend : Status

Small multiples : Year from the hierarchy generated by default

Tooltips : Row Count & Unique Ticket

If you place Row Count first in the tooltip, the resultat is wrong (50 unique ticket in march 2025 with the "In progress" status).

If you place Unique ticket first in the tooltip, the result seem OK (11 unique ticket in march 2025 with the "In progress" status)Row Count First incorrect valueRow Count Last correct value