Count showing wrong compare to bar chart

Hello BalajiBuddha 

try this 

Quantity by Owner and Snapshot Date =
VAR AutomationSelected =
CONTAINS (
VALUES ( OPEN_OPPORTUNITY_EVOLUTION_C4C[Opportunity Type] ),
OPEN_OPPORTUNITY_EVOLUTION_C4C[Opportunity Type],
"Automation"
)

/* Detect if we are in a single-month row or in a total/subtotal row */
VAR IsMonthLevel =
HASONEVALUE ( 'CALENDAR'[Month] ) -- swap to [YearMonth] or whichever
-- column drives your axis

RETURN
IF (
IsMonthLevel,

/* ── SINGLE MONTH ROW ── same logic as before */
VAR MonthStart =
DATE ( YEAR ( MAX ( 'CALENDAR'[Date] ) ), MONTH ( MAX ( 'CALENDAR'[Date] ) ), 1 )
VAR MonthEnd = EOMONTH ( MonthStart, 0 )
VAR SnapshotDateSelected =
CALCULATE (
MAX ( OPEN_OPPORTUNITY_EVOLUTION_C4C[Snapshot Date] ),
OPEN_OPPORTUNITY_EVOLUTION_C4C[Snapshot Date] >= MonthStart,
OPEN_OPPORTUNITY_EVOLUTION_C4C[Snapshot Date] <= MonthEnd
)
VAR CloseDateEnd = EOMONTH ( MonthStart, 11 )
RETURN
IF (
ISBLANK ( SnapshotDateSelected ),
BLANK (),
CALCULATE (
SUMX (
SUMMARIZE (
OPEN_OPPORTUNITY_EVOLUTION_C4C,
OPEN_OPPORTUNITY_EVOLUTION_C4C[Opportunity Key],
OPEN_OPPORTUNITY_EVOLUTION_C4C[Sales Cycle Phase],
"Qty_Clean", SUM ( OPEN_OPPORTUNITY_EVOLUTION_C4C[Quantity] )
),
[Qty_Clean]
),
OPEN_OPPORTUNITY_EVOLUTION_C4C[Snapshot Date] = SnapshotDateSelected,
OPEN_OPPORTUNITY_EVOLUTION_C4C[Potential Close Date] >= MonthStart,
OPEN_OPPORTUNITY_EVOLUTION_C4C[Potential Close Date] <= CloseDateEnd,
FILTER (
'PRODUCT_STRUCTURE_C4C',
NOT AutomationSelected
|| NOT ( 'PRODUCT_STRUCTURE_C4C'[Model] IN {
"Automation Analysis", "Project", "Peripherals",
"Change Request", "LSI", "Software", "System Support"
} )
)
)
),

/* ── TOTAL / SUBTOTAL ROW ──
Iterate each distinct month visible in the current filter context
and SUM the per-month results so the total = sum of bar chart values */
SUMX (
VALUES ( 'CALENDAR'[Month] ), -- same column as IsMonthLevel check above
VAR MonthStart =
DATE ( YEAR ( MIN ( 'CALENDAR'[Date] ) ), MONTH ( MIN ( 'CALENDAR'[Date] ) ), 1 )
VAR MonthEnd = EOMONTH ( MonthStart, 0 )
VAR SnapshotDateSelected =
CALCULATE (
MAX ( OPEN_OPPORTUNITY_EVOLUTION_C4C[Snapshot Date] ),
OPEN_OPPORTUNITY_EVOLUTION_C4C[Snapshot Date] >= MonthStart,
OPEN_OPPORTUNITY_EVOLUTION_C4C[Snapshot Date] <= MonthEnd
)
VAR CloseDateEnd = EOMONTH ( MonthStart, 11 )
RETURN
IF (
ISBLANK ( SnapshotDateSelected ),
0,
CALCULATE (
SUMX (
SUMMARIZE (
OPEN_OPPORTUNITY_EVOLUTION_C4C,
OPEN_OPPORTUNITY_EVOLUTION_C4C[Opportunity Key],
OPEN_OPPORTUNITY_EVOLUTION_C4C[Sales Cycle Phase],
"Qty_Clean", SUM ( OPEN_OPPORTUNITY_EVOLUTION_C4C[Quantity] )
),
[Qty_Clean]
),
OPEN_OPPORTUNITY_EVOLUTION_C4C[Snapshot Date] = SnapshotDateSelected,
OPEN_OPPORTUNITY_EVOLUTION_C4C[Potential Close Date] >= MonthStart,
OPEN_OPPORTUNITY_EVOLUTION_C4C[Potential Close Date] <= CloseDateEnd,
FILTER (
'PRODUCT_STRUCTURE_C4C',
NOT AutomationSelected
|| NOT ( 'PRODUCT_STRUCTURE_C4C'[Model] IN {
"Automation Analysis", "Project", "Peripherals",
"Change Request", "LSI", "Software", "System Support"
} )
)
)
)
)
)

if possible share pbix