Forum Discussion
Simple_one
Helper I
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 Re...
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
Super User
Super UserSimple_one ok, but which is the logic to obtain 156 for 03-2023?
Simple_oneHelper I
Helper IHi 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
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