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,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Done! 

Sorry for being late, I was away.

 

Thank you very much!