5 Replies Latest reply: Oct 3, 2018 9:04 PM by Wong Dehou RSS

    How to combine 2 set analysis

    Wong Dehou

      Hi all,

       

      Currently, I am using this measure below. Is it possible to combine all of this? I tried using sum() but it did not work.

       

      count(distinct {<[Current score]={"< $(APlusSlider)"},[Current_Grade]= {'A+'}>}[Student_name])


      + count(distinct {<[Current score] = {">= $(ASlider)"},[Current_Grade]= {'B+'}>}[Student_name])


      + count(distinct {<[Current score] = {">= $(ASlider)"},[Current_Grade]= {'B'}>}[Student_name])



      Much help is appreciated.


      Thank you.