Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summarize with multiple filtering

Hi,    I'm beginner in DAX and I have a problem: a table called 'DVENDAS' with this columns: [Ticket], [Agency], [ServiceDate], [Service], [Source], [Destination], [Status] and more;   And I'm tr...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

     

    Try this formula, please.

    Table =
CALCULATETABLE (
    SUMMARIZE (
        DVENDAS;
        DVENDAS[Ticket];
        DVENDAS[Agency];
        DVENDAS[ServiceDate];
        DVENDAS[Service];
        DVENDAS[Source];
        DVENDAS[[Destination];
        DVENDAS[Status]
    );
    FILTER (
        DVENDAS;
        DVENDAS[Agency] IN { "SITE"; "PORTAL" }
            && DVENDAS[Status] = "CHANGE"
    )
)

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

 

Try this formula, please.

Table =
CALCULATETABLE (
    SUMMARIZE (
        DVENDAS;
        DVENDAS[Ticket];
        DVENDAS[Agency];
        DVENDAS[ServiceDate];
        DVENDAS[Service];
        DVENDAS[Source];
        DVENDAS[[Destination];
        DVENDAS[Status]
    );
    FILTER (
        DVENDAS;
        DVENDAS[Agency] IN { "SITE"; "PORTAL" }
            && DVENDAS[Status] = "CHANGE"
    )
)

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks a lot, v-jiascu-msft!

     

    And what if I want to filter by [Agency] equals "SITE" and "PORTAL" AND [Status] equals "CHANGE" AND [SalesType] equals "PTA"?

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

      You can add more conditions to the filter part. Which table is [SalesType] in?

      Table =
CALCULATETABLE (
    SUMMARIZE (
        DVENDAS;
        DVENDAS[Ticket];
        DVENDAS[Agency];
        DVENDAS[ServiceDate];
        DVENDAS[Service];
        DVENDAS[Source];
        DVENDAS[Destination];
        DVENDAS[Status]
    );
    FILTER (
        DVENDAS;
        DVENDAS[Agency] IN { "SITE"; "PORTAL" }
            && DVENDAS[Status] = "CHANGE"
            && DVENDAS[SalesType] = "PTA"
    )
)

      Best Regards,

      Dale

      • JoaqBI's avatar
        JoaqBI
        Regular Visitor
        3 years ago

        Hi All,

        I am having a similar issue but instead of filtering like this

            FILTER (
        DVENDAS;
        DVENDAS[Agency] IN { "SITE"; "PORTAL" }
            && DVENDAS[Status] = "CHANGE"
            && DVENDAS[SalesType] = "PTA"
    )

         I would like to filter :

            FILTER (
        DVENDAS;
        DVENDAS[Status] = SELECTEDVALUE(Dvendas[STATUS])
        )

         Having a Slicer with all the values for Dvendas[STATUS] for the user to select. This does not work, for some reason it doesn't filter. 
        Do you know why Filtering with a SELECTEDVALUE instead of with a specific text "CHANGE" does not work in this situation ? 
        Thanks a lot.