topic Re: Need help on Dax in DAX Commands and Tips

Need help on Dax

Simple_one — Wed, 24 Jul 2024 07:27:08 GMT

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

Re: Need help on Dax

BeaBF — Wed, 24 Jul 2024 07:34:55 GMT

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

Re: Need help on Dax

Simple_one — Wed, 24 Jul 2024 08:08:19 GMT

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 ?

Re: Need help on Dax

BeaBF — Wed, 24 Jul 2024 08:14:10 GMT

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

Re: Need help on Dax

Simple_one — Wed, 24 Jul 2024 08:39:46 GMT

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

Re: Need help on Dax

BeaBF — Wed, 24 Jul 2024 08:48:56 GMT

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

Re: Need help on Dax

Simple_one — Wed, 24 Jul 2024 09:11:35 GMT

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 ?

Re: Need help on Dax

BeaBF — Wed, 24 Jul 2024 09:55:22 GMT

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

Re: Need help on Dax

Dyuti_M9 — Thu, 15 Aug 2024 11:28:11 GMT

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?

Re: Need help on Dax

Dyuti_M9 — Thu, 15 Aug 2024 11:29:49 GMT

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?