Problem with Measure and Filter

[Syndicate_Admin]

Hello, I hope you can help me, I have a Measure where the accumulated "stocks" is calculated, however, when I want to apply a filter on the types of tests to be carried out, it shows me the accumulated in general and not by type of test. In the first photo you can see the general stock, but when choosing a type of "Essay" the same stock remains (Photo 2)

Here it should be the Stock = -28

Similarly I attach the code of the Measure:

[Syndicate_Admin]

I work for what I wanted, I also correct another problem I had when using the date filter, only correct a part since I made reference to another table but just change the name of the table and it worked, thank you very much!

[v-henryk-mstf]

Hi @Syndicate_Admin ,

Thanks for your feedback.

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,
Henry

[v-henryk-mstf · Accepted solution]

Hi @Syndicate_Admin ,

According to the formula you provided, the reason for this kind of problem is that the formula uses the all function, which clears all filters of the table, so when you filter the values in the filter, it does not affect Stock.
You can try the following formula (keeping the filter results for the ensyo field).

M =
VAR ent =
    CALCULATE (
        COUNTROWS ( MiniEntrada ),
        FILTER (
            ALLEXCEPT ( MiniEntrada, MiniEntrada[Ensayo] ),
            MiniEntrada[ENT_STA] = "IN"
                && MiniEntrada[ENT_FECHA] <= MIN ( MiniEntrada[ENT_FECHA] )
        )
    )
VAR pro =
    CALCULATE (
        COUNTROWS ( MiniProd ),
        FILTER (
            ALLEXCEPT ( MiniProd, MiniProd[Ensayo] ),
            MiniEntrada[ENT_STA] = "out"
                && MiniProd[ENT_FECHA] <= MIN ( MiniProd[ENT_FECHA] )
        )
    )
RETURN
    ent - pro

If the problem is still not resolved, please provide detailed error information and And provide test data to facilitate me to solve for you as soon as possible. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.