DAX query assistance

[andrmh]

Hi All,

I have what should be a very simple query.

(Note - this is ficticious data to describe what im trying to do)

I have a Table, Fruits.
In it, is an Id, a date, a category.

(SAMPLE)

and so on...

I am displaying a table, which contains a breakdown by month/year (related to a date dimension), the category, and the count of all fruits, slided by date and category as follows:

What I need, is the Period column at the end. This should simply be the sum of all fruit for that month (as displayed).
However I cant seem to crack it.

The end goal, is to use that monthly total to arrive at a % of total that each category represents. However we have a requirement to display the totals used to arrive at that percentage also.

Items is simply a Count of distinct ID's, no filters or anything like that applied. Save what the slicers for the visual itself are applying.

I have tried using ALLEXCEPT but dont seem to be making any headway.

I have tried:

Period = CALCULATE( count(Fruits[Id]), ALLEXCEPT(vDimDate, vDimDate[Date]))

Period = CALCULATE( count(Fruits[Id]), ALLEXCEPT(vDimDate, vDimDate[MonthNameLabel]))

Period = CALCULATE( count(Fruits[Id]), ALLEXCEPT(Fruits, Fruits[Date]))

None seem to yield the right result. Im likely missing something very very simple at the moment.

Assistance appreciated.

Thanks.

[andrmh · Accepted solution]

Period = CALCULATE( count(Fruits[Id]), ALLSELECTED(Fruits[Category]))

seems to have done the trick.