Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Problem with Measure and Filter

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)

Kddk852_1-1652727359095.png

Here it should be the Stock = -28

Kddk852_2-1652727427961.png

Similarly I attach the code of the Measure:

Kddk852_3-1652727463922.png

  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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.

3 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    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.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    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's avatar
      v-henryk-mstf
      Community Support
      4 years ago

      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