Forum Discussion

kh3ldar's avatar
kh3ldar
Copper Contributor
May 07, 2023
Solved

Pivot, Dax Formula and Slicer

Hello, I'm new to DAX functions. I need to create a measure that is based on the Selected Value from a slicer. This is my formula: =MAXX(FILTER(RawP, RawP[Month]=SELECTEDVALUE(Slicer_Month...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    May 08, 2023

    kh3ldar 

    SELECTEDVALUE() was introduced for the Excel data model recently, I guess it's still on insider channels only. 

    Alternatively you may use

    myMeasuer:= MAXX (
    FILTER (
        RawP,
        RawP[Month] = IF ( HASONEVALUE ( RawP[Month] ), VALUES ( RawP[Month] ) )
    ),
    RawP[Ex SS]
)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 08, 2023

kh3ldar 

SELECTEDVALUE() was introduced for the Excel data model recently, I guess it's still on insider channels only. 

Alternatively you may use

myMeasuer:= MAXX (
    FILTER (
        RawP,
        RawP[Month] = IF ( HASONEVALUE ( RawP[Month] ), VALUES ( RawP[Month] ) )
    ),
    RawP[Ex SS]
)

Resources