Forum Discussion
filter aux table with date slicer
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.
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