Wrong visual filtering in Power BI

[Analitika]

Hello,

I have a problem 

When selecting column in first visual, I am getting wrong visual in second visual. Second visual sum is 58163 while first visual shows 35 286. Both visuals use same measure like this:

Prekės likutis, EUR (KATEGORIJA) = 

    CALCULATE (
       [Likutis, Eur],
        FILTER (
            DISTINCT (ALL(I27[I27_KODAS_PS] )),
            COUNTROWS (
                FILTER (
                   'Pasirinkti_sandeliams',
                   [17_1_1_Pasiskirstymas pagal kategorijas]='Pasirinkti_sandeliams'[Kategorijos]
                )
            ) > 0
        )
    )

Kategorijos are 

Kategorijos ar categories: filter final sum by category. So what I am doing wrong?

[v-mengmli-msft]

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

[Analitika]

Likutis, Eur = [Suma kaupiamas]+sum(I27[I27_PIN_SUMA])

Suma kaupiamas = CALCULATE(sum('I27'[I27_PIN_SUMA]), FILTER(ALL('Date'[Date]),'Date'[Date]<MIN('Date'[Date])))

Here formulaes

[rohit1991]

The issue likely stems from nested FILTER logic or improper relationships. Here's a simplified version of your formula for debugging:
|

Prekės likutis, EUR (KATEGORIJA) =
CALCULATE(
[Likutis, Eur],
FILTER(
ALL(I27[I27_KODAS_PS]),
[17_1_1_Pasiskirstymas pagal kategorijas] IN VALUES('Pasirinkti_sandeliams'[Kategorijos])
))

[Analitika]

HI,

After I am getting the same result. Here example:

The result of second visual is 34450 instead of 27789. Why I am getting wrong filtering.