Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dax/selectedvalue

Hi,   Measure = IF ( YEAR ( SELECTEDVALUE('Calendar'[Date] )) = YEAR ( TODAY () ) && MONTH ( SELECTEDVALUE('Calendar'[Date] )) = MONTH ( TODAY () ), "Yes", "No" )   can anyone clar...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Replace SELECTEDVALUE() with MIN().

    Hope this helps.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous 

 

your slicer returns a range and not one distinct value.

 

SELECTEDVALUE

Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.

https://docs.microsoft.com/en-us/dax/selectedvalue-function

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi mwegener 

     

    Could you please tell me what can i use instead of selected value to get the above requirement. i used values also still my requirement is not working.

     

     

    Thank you.

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Hi Anonymous 

       

      use MIN

       

       

      Measure =
IF (
    YEAR ( MIN ( 'Calendar'[Date] ) ) = YEAR ( TODAY () )
        && MONTH ( MIN ( 'Calendar'[Date] ) ) = MONTH ( TODAY () );
    "Yes";
    "No"
)

       

       

      If I answered your question, please mark my post as solution, this will also help others.

      Please give Kudos for support.

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Anonymous  as Ashish_Mathur suggest, use MIN or MAX function to get the single value from the date range.

       

      Measure = 
IF (
YEAR ( MIN('Calendar'[Date] )) = YEAR ( TODAY () )
&& MONTH ( MIN('Calendar'[Date] )) = MONTH ( TODAY () ),
"Yes",
"No"
)

       

      Depending on how you want logic to work, change MIN to MAX. For example, if you have selected date Aug 01, 2019 to Nov 30th 2019, MIN will return Aug 01, 2019 and will compare against TODAY(),  MAX will return Nov 30th, 2019 and will compare against TODAY()