Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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))
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |