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.