filter aux table with date slicer

[Anonymous]

Hello,

I have a slicer date filter in my report.

I have also a tipical table called Reading with columns: name, date and amount.

I created an auxiliary table as follow:

Capa = ADDCOLUMNS(SUMMARIZE('Reading','Reading'[Name],"Average of Amount",AVERAGE('Reading'[Amount])),"Ranges",SWITCH(TRUE(),[Average of Amount]>1.5,"Critical","Other"))

The problem is that the auxiliary table doesnt considere the page date slicer filter. How can I do to Capa table consideres tha date slicer filter of the page?

[v-jiascu-msft]

Hi @Anonymous,

Do you mean the auxiliary table is a calculated table? If so, the slicer can't filter it directly. You need to create a visual based on the auxiliary table. 

Best Regards!

Dale

[Anonymous]

yes, the auxiliary table called "capa" is a calculate table with columns, Name, Average of Amount and Description. The description is a switch that decides depend the result on Average Of Amount.

I did not understand well your asnwer, in the calculate table I dont have the date, should I add the date in the calcuate table? If I added it the average is not calculated well as the avg will be calculated per day and name and I want just the avg per name but filter by all dates in the date slicer.

[v-jiascu-msft]

Hi @Anonymous,

The point is the slicer can't filter the calculated table directly even the calculated table has a date column. Can you try to use the formula in a measure? What do you want in a visual exactly? Maybe you can share a sample.

Best Regards!

Dale