I am working on a report which is expected to provide both daily and monthly insights on the same page. I have set a page level filter on today’s date. So all my visuals are filtered for current date when the report is loaded. Now I also need to show some monthly trends like new accounts, created in last month. Following your videos I have come up with the DAX formula.
New Accounts 1M = CALCULATE([New accounts],DATESINPERIOD(DateTable[Date],TODAY(),-1,MONTH),ALL(DateTable[Date]))
But the page level filter still applies and I get just one value for todays date.
Can you please let me know how to get this fixed.
Thanks in advance.