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.
Hi,
I have created a table that only holds Measures which uses fields from another table and I want to be able to use filters on the Measures. But it doesnt seem to work at the moment? Do I need to create a join/relationship between the tables?
The reason why I have created a Measure table is so that I can manage the Measures easily as well as be able to create a custom table with the right format... etc show Sold Volume (num) and Sold % after it, in the table. How do I make the filters work with this?
Thanks.
Solved! Go to Solution.
I have found the solution to my problem - https://community.powerbi.com/t5/Desktop/Create-Dynamic-Summary-Table-Using-Results-of-Measures/td-p...
Thanks
I have found the solution to my problem - https://community.powerbi.com/t5/Desktop/Create-Dynamic-Summary-Table-Using-Results-of-Measures/td-p...
Thanks
Hi @shyammayhs ,
Do you have ALL() function in your measure? Are you using visual level filter or page level filter?
Please show more information to us.
Best Regards,
Jay
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
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
Hey @shyammayhs
What do you mean by using filters on the table? Can you demonstarte with an example?
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |