Filter calculated table using slicer

eliottbbedard — Tue, 26 Sep 2023 14:09:01 GMT

Hello,

I would like to be able to filter a calculated table using slicers on my PBI report. I use a master table that contains several data items (reception dates, value used for slicers, etc.) and a date table to show the number of applications received by week. I created a relationship between the reception date and the date table, a measure to calculate the number of applications received and added a custom column (CFP 2023 by week) to my date table to define the week the application was received. After that, I created a calculated table to display the number of applications received per week.

My table is working correctly but I'd like to be able to use the information in the master table to filter the information in the calculated table. Could someone help me make this work?

Here is the details of my calculated table:

Application Received by Week = ROW( "Week", "Application Received", "1", CALCULATE([Number of Projects], 'Date'[CFP 2023 by Week] = "Week 1"), "2", CALCULATE([Number of Projects], 'Date'[CFP 2023 by Week] = "Week 2"), "3", CALCULATE([Number of Projects], 'Date'[CFP 2023 by Week] = "Week 3"), "4", CALCULATE([Number of Projects], 'Date'[CFP 2023 by Week] = "Week 4"), "5", CALCULATE([Number of Projects], 'Date'[CFP 2023 by Week] = "Week 5"), "6", CALCULATE([Number of Projects], 'Date'[CFP 2023 by Week] = "Week 6"), "7", CALCULATE([Number of Projects], 'Date'[CFP 2023 by Week] = "Week 7"), "8", CALCULATE([Number of Projects], 'Date'[CFP 2023 by Week] = "Week 8"), "9", CALCULATE([Number of Projects], 'Date'[CFP 2023 by Week] = "Week 9"), "Total", CALCULATE([Number of Projects], NOT(ISBLANK('Date'[CFP 2023 by Week]))) )

Table in the report:

Thanks a lot for your help!

Re: Filter calculated table using slicer

Anonymous — Thu, 28 Sep 2023 01:39:39 GMT

Hi eliottbbedard ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Filter calculated table using slicer in DAX Commands and Tips

Filter calculated table using slicer

Re: Filter calculated table using slicer