Max Sum of individual days but ignoring filters

[ElliotCartlidge]

Hello,

As the subject suggests i've been attempted to create a measure which finds the highest day total of a unit but ignoring filters.

I worked out how to calculate the highest day total, but can't get it to ignore filters. Below is what i am using.

Highest Day Total = maxx(SUMMARIZE('Manufactured Items','*KEEP*Date'[Date],"Total",SUM('Manufactured Items'[SMU])), [Total])

How do i get this forumla to ignore Date filters.

Kind regards,

Elliot

[SpartaBI · Accepted solution]

@ElliotCartlidge try:

Highest Day Total =
MAXX (
	ADDCOLUMNS(
        ALLSELECTED(*KEEP*Date'[Date]),
        "Total",CALCULATE(SUM ( 'Manufactured Items'[SMU] ))
    ),
    [Total]
)

      

Showcase Report – Contoso By SpartaBI

[ElliotCartlidge]

That worked perfectly, looks like I need to filter for certain years in the date table though now. Please can you suggest how I'd alter what you've created to look at only 2022 and 2021?

[SpartaBI]

@ElliotCartlidge you can add any filter you want outside the visual (filter pane / slicer / other visual ) and if you will select there only these years it will work as expected.
ALLSELCETED only ignors filters from inside the same visual (in a simple explanation, it actually does something much more complex with shadow filters, but the outcome is that it ignors filters from inside the visual and retain filters from outside the visual).

      

Showcase Report – Contoso By SpartaBI