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 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_oneHelper I
Helper IHi 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