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 want to be able to use filters on the Measures (measure table) that I have created - but at the moment, no filters seem to be working with the Measures?
I still do not understand in what scenarios you will like to filter the measures? Measures return scaler values, and you can only use them in the values segment of a visual (along with tooltips).
The table created to store the measures are not essentially a regular data table.
Is it possible for you to demonstrate with an example? Do you mean that you want to use meausres in slicer and then by changing selection different measures, it shows different results on the same visual?
Cheers!
Vivek
If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter