Forum Discussion
Solved
How to Filter a Summary Table Based on Original Table
Hi there I'm working on a project management dashboard and one viz I'm trying to build is related to workload. My main data set has 6 columns: Project Phase | Task | Status | Lead | Support1| Suppo...
Just in case someone else encounters this - I resolved my issue by creating a copy of my query and unpivoting the 3 columns I needed. I then created some count metrics for each and then built the viz. Worked like a charm.
amitchandak
Super User
Super Usermikegoalie , You have to join this new table back Phase, Task, and status dimension to filter.
Calculated table can not take slicer values. So you have use the dimensions/joined tables to filter data
Thanks for the response. Can you walk me through how i may do that? I'm not having any luck.
here is a sample of my scenario and issue: https://github.com/mikegoalie/PowerBI/blob/main/Sample.pbix