Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to add Pagefilter into Measure

In my report a have valid data at the beginning of June 2022 and therefore I added this criteria to "Filter on all pages". Now I have a previous year measure (PY), which uses sameperiodlastyear(). ...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi, Anonymous 

Have you tried to create a custom measure and apply to 'filter on this visual'?

Can you share a sample file for further research?

 

Best Regards,
Community Support Team _ Eason

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    My Problem is not to filter a visual. My Problem is that if I filter the Report-Date by a Date via "Filter on all Pages" (example >= April 2008), but using a Previous Year Measure then I get also values from dates < then April 2008.
    Therefore, how can I add this "All pages filter" to my Calculation Measure ? 

    My expectation is that this cell should all be empty


    Here you can find a test driver https://1drv.ms/u/s!AisdRKk9qLVVgt8i-IhvdXip2nx9Wg?e=b7tIoP