Need help on Dax

[Simple_one]

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 Reenrol

Besides, the result of Number of ReEnrol is not correct ( the correct number is 777)

I think my dax for calculating of # of Reenrol is wrong . Please help me to make this matrix can present like:

When I chosen the months in Slicer, just present the correct : # of Offtrack and # of Reenrol

I have a power BI in this link : https://drive.google.com/file/d/1wTIRIYZwen1DQZa0caWyGjAnjINpNoQ7/view?usp=drive_link 

Please help me for this dax! Thank you very much

[Dyuti_M9]

Hi I want to calculate the difference in sales volume per interval of minute as given in the table below however I am getting the wrong result. Can you please help?

[Dyuti_M9]

Hi I want to calculate the difference in sales volume per interval of minute as given in the table below however I am getting the wrong result. Can you please help?

[BeaBF]

@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]

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]

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

[Simple_one]

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]

@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

[Simple_one]

Hi @BeaBF 

It correct , but the matrix is present the Month that I am not select in the Slicer (as 2023-10, 2023-11, ....)? Can you help me fix this ?

[BeaBF · Accepted solution]

@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