9 Replies Latest reply: Nov 22, 2017 8:24 AM by omar bensalem RSS

    Individual Month Percentages

    saad zaman

      Hi All,

       

      I am actually struggling to get the %age for individual months

       

      My Measure looks like:

       

      sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

      /

      Sum (TOTAL {<ABC-={'181 and Above'},DEF={'APPROVED'},MonthYear>}[XXX])

       

      I have also tried below :

       

      sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

      /

      Sum (TOTAL {<ABC-={'181 and Above'},DEF={'APPROVED'}>}MonthYear[XXX])

       

      But this does not give any result.

       

      Regards,

      Saad