DAX measure to change the way filters are getting affected.

[singhal14]

Hi everone,

We are trying a scenario where using DAX measure we are changing the filtered value .Here is the screenshot of the table. Here we are calculating the sum of value column by using col1 and col2. So when we place col1 in the slicer and chose a the filtering should be done on the basis of col2 and sum of valueshould be 30 . 

If you need any clarification on this problem, please let us know.Any help would be useful.

Thanks

[v-shex-msft · Accepted solution]

Hi @singhal14,

According to your description, you want to use slicer to choose the col2 and show sum of the value,right?

If this is a case, you can refer to below steps to achieve your requirement.

Original table:

Calculate table:

Table = VALUES(Table1[col1])

Add a measure to new table to get slicer's value.

Selected = if(HASONEVALUE('Table'[col1]),VALUES('Table'[col1]),BLANK())

Add measure to original table to calculate summary value.

TotalValue =
var temp=LOOKUPVALUE(Table1[col2],Table1[col1],[Selected])
return
SUMX(FILTER(ALL('Table1'),'Table1'[col2]=temp),[value])

Add the relationship between original table and calculate table.

Create visuals.

Slicer:

Table visual:

Result:

Regards,

Xiaoxin Sheng