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'm just wondering which is best practice, to either build filters into my measures, or to use the filters on reports.
I have, as an example, a measure telling me the total number of outstanding tickets our team needs to answer.
I also want to see this information by priority.
Example: 30 outstanding tickets; 15 High priority, 10 Medium priority, 5 Low priority.
Should I build a new measure for each priority, or should I use the filters on the report page to filter my total outstanding tickets measure?
Just wondering which is best practice as I know both work.
Many thanks for your help.
Solved! Go to Solution.
@lottieritchie , it depends on need. You have the option to use visual level filter.
but if you want them in the same visual, then you need separate measures. Please use filter and create separate measure
Hi,
This kinda depends on the reporting requirements. If a measure should always only show the high priority tickets, it may be best to hard code the filter into a measure, so that end-users can't accidentally change the filter. However, if your report users can receive extra value from the report by being able to compare how many tickets there are per category, you may be better off choosing a slicer or report filter.
hope it helps!
regards,
Tim
Proud to be a Super User!
Hi,
This kinda depends on the reporting requirements. If a measure should always only show the high priority tickets, it may be best to hard code the filter into a measure, so that end-users can't accidentally change the filter. However, if your report users can receive extra value from the report by being able to compare how many tickets there are per category, you may be better off choosing a slicer or report filter.
hope it helps!
regards,
Tim
Proud to be a Super User!
@lottieritchie , it depends on need. You have the option to use visual level filter.
but if you want them in the same visual, then you need separate measures. Please use filter and create separate measure
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |