Forum Discussion

Velvetine27's avatar
Velvetine27
Icon for Helper I rankHelper I
3 years ago
Solved

Multiple selection filters not working

Hi all,   I wrote a DAX to display data up till the selected month like this :    %CFR= VAR selectedYear =     SELECTEDVALUE ( 'DATE'[Date].[Year] ) VAR selectedMon =     SELECTEDVALUE ( 'D...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Velvetine27 

     try like:

    %CFR=
    VAR selectedYear =
        YEAR(MAX('DATE'[Date]))
    VAR selectedMon =
        MONTH(MAX('DATE'[Date]))
    VAR start_ =
        DATE ( selectedYear, 1, 1 )
    VAR end_ =
        DATE ( selectedYear, selectedMon + 1, 1 ) - 1
    RETURN
    CALCULATE(([DO] / [SO]),FILTER ( 'TABLE', 'TABLE'[date] >= start_ && 'TABLE'[date] <= end_ ))
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Velvetine27 

 try like:

%CFR=
VAR selectedYear =
    YEAR(MAX('DATE'[Date]))
VAR selectedMon =
    MONTH(MAX('DATE'[Date]))
VAR start_ =
    DATE ( selectedYear, 1, 1 )
VAR end_ =
    DATE ( selectedYear, selectedMon + 1, 1 ) - 1
RETURN
CALCULATE(([DO] / [SO]),FILTER ( 'TABLE', 'TABLE'[date] >= start_ && 'TABLE'[date] <= end_ ))