Forum Discussion
Helper INeed 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 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
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
9 Replies
- BeaBF
Super User
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_oneHi 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?
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?
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?
