Solved: TOTALYTD BASED ON MULTIPLE FILTERS

Anonymous · ‎01-15-2019

Hi,

I have the following YTD calculations:

YTD_inbound_lines_in_time = TOTALYTD(COUNT(Purchasing_data[OTD 0d]),Date_table[Date],Purchasing_data[OTD 0d]="On Time")

YTD_inbound_lines_early = TOTALYTD(COUNT(Purchasing_data[OTD 0d]),Date_table[Date],Purchasing_data[OTD 0d]="Early")

Now I want to combine "on time" and "early" in one TOTALYTD calculation called YTD_inbound_lines_in_time_and_early. This means that the inbound lines on time and early are added to one number.

I tried with && within the filter, but that does not work.

Does anyone has a solution?

AlB · ‎01-15-2019

Hi @Anonymous

Can you not add the two measures you have?

Have you tried with || , since you want both:

YTD_inbound_lines_in_time_OR_early =
TOTALYTD (
    COUNT ( Purchasing_data[OTD 0d] ),
    Date_table[Date],
    Purchasing_data[OTD 0d] IN { "On Time", "Early" }
)

But this measure should provide the same result as adding the two you already have. Each item can be either "On Time" or "Early", right?

View solution in original post

v-jiascu-msft · ‎01-24-2019

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

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

AlB · ‎01-15-2019

Hi @Anonymous

Can you not add the two measures you have?

Have you tried with || , since you want both:

YTD_inbound_lines_in_time_OR_early =
TOTALYTD (
    COUNT ( Purchasing_data[OTD 0d] ),
    Date_table[Date],
    Purchasing_data[OTD 0d] IN { "On Time", "Early" }
)

But this measure should provide the same result as adding the two you already have. Each item can be either "On Time" or "Early", right?