Forum Discussion

Simple_one's avatar
Simple_one
Icon for Helper I rankHelper I
2 years ago
Solved

Need help on Dax

Hello everyone, I have a problem in this visual of Power BI below :       I chosen 3 Months in Slicer : 01-2023, 02-2023, 03-2023 but the visual present all of the months have number of Re...
Need Help
  • BeaBF's avatar
    BeaBF
    2 years ago

    Simple_one You can create a calculated column:

    CHECK_DATE = IF('Offtrack Reenrollment'[OFFTRACK_YM] = 'Offtrack Reenrollment'[YEAR_MONTH], 1, 0)then put this column in filter pane of the matrix visual and select "equals 1":

     

    it will show you only the desidered dates:

     

     

    BBF

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
2 years ago

Simple_one Hi! I'm on your pbix file, why is that number wrong? If I put values in a table, the total is correct. Which is the calculation that should do the measure? and the expected output for row?

 

BBF

Simple_one's avatar
Simple_one
Icon for Helper I rankHelper I
2 years ago

Hi BeaBF ,

The # of Reenrol of 03-2023 is : 156 ( with my dax for calculate # of Reenrol ).

My dax for calculating of # of Reenrol is not correct. Can you help me for fixing this ?

  • BeaBF's avatar
    BeaBF
    Icon for Super User rankSuper User
    2 years ago

    Simple_one ok, but which is the logic to obtain 156 for 03-2023?

    • Simple_one's avatar
      Simple_one
      Icon for Helper I rankHelper I
      2 years ago

      Hi BeaBF ,

      I count Distinct number of USERINFORMATION_KEY in data for OFFTRACK_YM of 03-2023  = 156. Because student can reenrolment many time but we count this student one time

      • BeaBF's avatar
        BeaBF
        Icon for Super User rankSuper User
        2 years ago

        Simple_one Try with:

        # of Reenrol = CALCULATE(
        SUMX(DISTINCT(SELECTCOLUMNS('Offtrack Reenrollment'
            ,"ID",'Offtrack Reenrollment'[USERINFORMATION_KEY]
            ,"isReenrollment",'Offtrack Reenrollment'[ISREENROLL])),[isReenrollment]), 'Offtrack Reenrollment'[OFFTRACK_YM] in VALUES('Offtrack Reenrollment'[YEAR_MONTH]))
         

         

        if it's ok, please accept my answer as solution.

         

        BBF