Forum Discussion
Use filters on a Measure table
- 5 years ago
I have found the solution to my problem - https://community.powerbi.com/t5/Desktop/Create-Dynamic-Summary-Table-Using-Results-of-Measures/td-p/764458
Thanks
Hi vivran22
So, I have a table which holds the data.
I have then created another Table that holds just the Measures - for example '=sum(VolumeSold)'.
I have then added these Measures onto the dashboard as a chart. (At this point, the Measure table and the Data table are not joined or have any relationship)
I am now trying to add in Filters from the data table onto the dashboard (Dates etc) but when I select a value from the filter, the Measure I have added to the chart doesnt update.
Hope that helps clear it up.
Can you share a sample file along with expected outcome?
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter