Wrong visual filtering in Power BI

Hi

It looks like the issue is coming from how the filters are being applied in your DAX measure, especially when using ALL('Date') inside your CALCULATE. When you do this, you’re removing all date filters, which can accidentally ignore your category context and give the wrong totals in your visuals.

To make sure your measure respects the selected category in the visual, I recommend using KEEPFILTERS along with VALUES. This ensures that the measure only calculates within the current filter context (like the category selected in your chart or slicer).\

Try updating your measure like this (replace table/column names as needed):

Suma kategorimai =
CALCULATE(
    [Suma],
    FILTER(
        ALL('Date'),
        'Date'[Date] <= MAX('Date'[Date])
    ),
    KEEPFILTERS(VALUES('Kategorija'[KategorijaID]))
)

This pattern will ensure you always get the correct total for the selected category in each visual, even with slicers or multiple charts on the page. If you want the measure to also respect page and report filters, you can use ALLSELECTED('Date') instead of ALL('Date') in your FILTER.

Also, double-check that your relationships between tables are correct and active.

Hi Analitika ,

Are the fields of both visualizations the same table? Could you please provide some example data? What are the parameters in your DAX?

Best regards,

Mengmeng Li