ALLExcept in Table Visual

[BigLo]

Hi,

I've a table visual where I want to display the values by people. I have 2 columns, the first managed with a slicer (sumCat1), another which represents the sum of the last month (SumCat1Month).

Step 1: The SumCat1Month work great but is it possible to distribute the measure to each person? Here I've the sum for all people on each line. I thought the exception on the idname would allow me to do this.

Step2: is it possible to use a filter on a table linked with an allExcept?
In my measure 'SumCat1' I filter on the Category table 'Filter (Category, Category [Category] = 1))'.  In my measure 'SumCat1Month' I selected the SubCategory because I cannot use a linked table.

Visual Example

Data

[BigLo]

The result of SumCat1Month is the sum for all, not for each person.

I share pbix

PBIX 

[V-lianl-msft · Accepted solution]

Hi @BigLo ,

Please try this:

SumCat1Month = CALCULATE(SUM('Values'[Value]),Filter('Values',('Values'[SubCategory]=1 || 'Values'[SubCategory]=2) && 'Values'[Date]>DATE(2021,5,1)),ALLEXCEPT('Name','Name'[Id]))+0

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@BigLo ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.