Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
54 | |
25 | |
23 | |
15 | |
11 |
User | Count |
---|---|
77 | |
61 | |
47 | |
18 | |
12 |