sum of hours excluding few TRCs.

[Anonymous]

Hi All,

I need DAX formula to calculate sum hours of Non_billable project where TRC  is "NB" and not "holiday public" or "paternity" or floating holiday etc. Please help with this. 

Employee Name	Hours	Project Name	TRC
A	8	Non_billabe	NB
B	8	Non_billabe	Holiday Public
C	8	Non_billabe	Paternity
D	8	Non_billabe	Floating Holiday
E	8	Non_billabe	NB
F	8	Non_billabe	NB
G	8	Non_billabe	Bereavement
H	8	Non_billabe	Holiday Public

[MahyarTF · Accepted solution]

Hi,

As I understood, you want to calculate the Hours for the "NB", "paternity", "floating holiday".

If it is use the below code for creating the dax measure : 

Hours_Sum =

            CALCULATE(sum(Sheet46[Hours]),

                      filter(Sheet46, Sheet46[Project Name] = "Non_billabe"),

                      filter(Sheet46, Sheet46[TRC] in {"NB", "paternity", "floating holiday"})

                    )

If you want others condition you could change it or use And / Or function in your dax code like :

or(or(and(Sheet46[TRC] = "NB",

                                                (Sheet46[TRC] <> "holiday public")),

                                            Sheet46[TRC] = "paternity"),

                                        Sheet46[TRC] = "floating holiday")

Appreciate your Kudos and please mark it as a solution if it helps you