Dynamic Filtering for each column for table

Anonymous — Tue, 02 Nov 2021 14:45:49 GMT

Hi

I would like to calculate the value where one particular column should not be affected by one of the filter .

Dataset -

I would like to sum the number for each value present in Column1 - I have two filters (Color Code and Category)
The column with pink header should be calculated based on color code filter only.
The column with blue header should be calculated based on category code filter only.

Note - Numbers seen in the above table are wrong

Can someone please help me with the DAX?

Thank you in advance.

Re: Dynamic Filtering for each column for table

Jihwan_Kim — Tue, 02 Nov 2021 15:05:57 GMT

Hi,

Please check the below picture and the attached pbix file.

Base on color code: =

CALCULATE (

SUM ( Data[Number] ),

TREATAS ( VALUES ( Color[Color Code] ), Data[Color Code] )

)

Base on category: =

CALCULATE (

SUM ( Data[Number] ),

TREATAS ( VALUES ( Category[Category] ), Data[Category] )

)

topic Dynamic Filtering for each column for table in DAX Commands and Tips

Dynamic Filtering for each column for table

Re: Dynamic Filtering for each column for table