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 a measure:
Sales Budget (Risk) Trend = calculate(sum(Backlog[Sales Budget]),all(Backlog[ReportRank]))
Solved! Go to Solution.
Hi @Anonymous ,
In your scenario, there is no method to ignore page level filters for ReportRank field and Date field.
Reserve your original DAX formula to create Reports measure, remove ReportRank field field from page level filters, then create a slicer using ReportRank field. Click each slicer and select “Edit interactions” under Format ribbon, then select “None” for the visuals that you use Reports measure to create, this way, when you select values in slicers, you will get your expected result.
Another way is to use visual level filters for each visual in the page.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
In your scenario, there is no method to ignore page level filters for ReportRank field and Date field.
Reserve your original DAX formula to create Reports measure, remove ReportRank field field from page level filters, then create a slicer using ReportRank field. Click each slicer and select “Edit interactions” under Format ribbon, then select “None” for the visuals that you use Reports measure to create, this way, when you select values in slicers, you will get your expected result.
Another way is to use visual level filters for each visual in the page.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , I doubt you can remove the page level filter. Try this
Sales Budget (Risk) Trend = calculate(sum(Backlog[Sales Budget]),all(Backlog))
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |