1 Reply Latest reply on Oct 5, 2017 2:28 PM by patrick.byrne.0

    Measure connected to filters

    Jakub Wludyka

      Hi everyone,

      I need your help. I create measure which shows percentage cost in profits (for 12 months). The formula looks:

      WINDOW_sum(SUM([cost]),-11,0)/[revenues]

       

      Now I need to prepare two similar measure:

      - one which not depends on all filters in worksheet/dashboard;

      - one which not depends on selected filters in worksheet/dashboard;

       

      Could you help me how to create it?

      Thanks for all answers.