topic Re: Get total of category without showing category in DAX Commands and Tips

Get total of category without showing category

Anonymous — Tue, 01 Dec 2020 13:50:48 GMT

Hi everyone,

I am stuck with a measure that should display the total of IDs for each category, but without showing the category.

Currently, I am able to display the column "Total ID by Country" using the following measure:

Total ID by Country = CALCULATE( COUNT(Mentions[ID]), ALLEXCEPT( Mentions, Market[Country] // Dimension table ) )

The problem is, as long as I remove the "Country" column, I get this result (column country should not be displayed):

The goal is to get this (Country column should not be displayed):

I don't think I can use a calculated column as this measure is sliced by other dimensions then.

Many thanks in advance for your help.

amitchandak — Tue, 01 Dec 2020 15:41:16 GMT

Anonymous , I doubt that will work without a country in context. But try this

Total ID by Country = CALCULATE( COUNT(Mentions[ID]), filter( allselected(Mentions), Market[Country] =max(Market[Country] ) // Dimension table ) )

Anonymous — Tue, 01 Dec 2020 16:21:03 GMT

amitchandakThanks for your answer.

Unfortunately, it does not solve my problem.

HotChilli — Wed, 02 Dec 2020 00:31:03 GMT

It will be either this or something close to it (depending on which fields make up the table)

Total ID by Country = CALCULATE( COUNT(Mentions[ID]), FILTER(ALL(Mentions), Mentions[Country] = MAX(Mentions[Country] ) ) )

Anonymous — Wed, 02 Dec 2020 07:50:12 GMT

HotChilli many thanks, it works!