Forum Discussion

Hayleysea's avatar
Hayleysea
Icon for Resolver II rankResolver II
6 years ago

Previous week measure not working

Hi there,   I have this measure to calculate a percentage of complete actions (works perfectly) % action complete =  IF(ISBLANK(COUNTX(FILTER(table, table[Cond Form]=4 && table[Do not count]="Co...
Need Help
Hayleysea's avatar
Hayleysea
Icon for Resolver II rankResolver II
6 years ago

Thanks amitchandak . I've made the changes (% action complete working good) and now I seem to be getting a percentage for the %previous week action complete but it's not changing when I apply filters to it but it remains as 66% no matter what filter.

 

Any ideas?

  • Hayleysea's avatar
    Hayleysea
    Icon for Resolver II rankResolver II
    6 years ago

    Thanks, it looks as though that doesn't make a difference. It seems that the Filter All function is stopping my visual level filter from applying (it works when I incorporate another filter all filter on the period after the week rank filter, just not when I use period as a visual level filter).

     

    I'm hoping I don't have to create new measures for every period since I can't use visual level ones 😞

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Hayleysea ，

       

      Can you upload your .pbix file to onedrive business and share the link with me?I need to test the measure to find the problem.

       

      Do remember to remove the confidential information before sharing.

       

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!