Dax count total occurrences without any filter

[bobmarley]

Hi there,

I have a following data.

I want to count total occurrence of the selected character from column1 regardless of any visual level, page level or report level filters. for eg. If i select character 'a' from column1 and number '2' from column2 in visual level filter power bi calculates count as 2 but there are total 4 'a' in column1. So I want total count as 4 not 2 i.e. ignoring any filter apply on that column or with respect to other columns. How can I achieve this in power bi using dax?

[v-yuezhe-msft · Accepted solution]

@bobmarley,

Based on your sample data, the total count of a is 5. Create the following measure in your  table.

Measure  = CALCULATE(COUNTA(Table[Column1]),ALLEXCEPT(Table,Table[Column1]))

Regards,

Lydia

[Larrauria]

Hi Lydia, thanks for your reply.

I have a similar issue but backwards. If I dont use any filter the formulas calculates the duplicates correctly, but as soon as I apply any slicer in the visual, the value remains calculating over the full table without filters. The issue in my case is that if I apply filters the calculation changes. Any clue on this one?. Thanks