I have a measure:
Sales Budget (Risk) Trend = calculate(sum(Backlog[Sales Budget]),all(Backlog[ReportRank]))
And I have a page-level filter Report Rank = 1. Report Rank is showing me which Report Date is the most recent one.
On the other hand, I have the area chart on which I want to use Report Date on X-axis and Sales Budget (Risk) Trend on Y-axis.
With this page-level filter Report Rank = 1, on the X-axis I see only the most recent date, whereas I should have seen more dates. Therefore, I wanted to use either all or removefilters , but none of them worked. They don’t change anything…
Does anyone know how to fix it?
Bottom: Current Status (Wrong)
Top: Desired Output
Pbi_dset.pbix (85.9 KB)