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