Forum Discussion
filter aux table with date slicer
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?
3 Replies
v-jiascu-msftMicrosoft Employee
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
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