DAX 'COUNTA' measure that ignores slicers

[MichaelHutchens]

Hi team, I'm hoping someone can help.

I have a DAX measure below that I'm using in a line graph to track how many conversations take place in an online forum over time. There is one conversation per row:

COUNT_TOTAL_MESSAGES = COUNTA(Email[Subject])

I have a slicer next to this line graph that I use to filter the line graph by the types of conversations, to see trends over time. But I'd like to add another line or column to this visualisation that shows total conversations over time, to give viewers a sense of what proportion the filtered conversations are of total conversations, for additional context.

This extra line needs to ignore the slicer, but the code below doesn't work:

UNFILTERED_COUNT_TOTAL_MESSAGES = CALCULATE(COUNTA(Email[Subject]), ALL(Email[Subject]))

Any idea what I'm doing wrong?

[MichaelHutchens]

Hi @Corey_M , thank you that worked 🙂 Your response has made me realise that what I actually need is a way to ignore the slicer, but also group conversations based on date. Otherwise, the DAX measure is giving me a total count of all conversations over all time, but displaying them in my line graph each month. Here's an example of how it looks now - the blue line is the modified DAX measure, and the date field is in the red box:

What do you think?

[Corey_M]

on further thought the crux of the issue is that the all on the measure clears the context of the filter that your x-axis (date heirarchy) provides, but you want it to ignore a slicer that operates also on your date heirarchy.  you might have more luck using your original measure but editing the interactions such that your slicer does not interact with your visual.

[Corey_M]

do you have a table for months and years? I have implemented something similar before. I just had to add something like this to the filter. 

Format('Email'[Date],"yyyy-MM") = Format(('DateTable'[Date]), "yyyy-MM")

[Corey_M]

is there a reason you aren't using ALL(Email) instead, I suspect the issue is that the ALL is clearing any filters on the Subject Column, but not whatever Time column your slicer acts on