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 clarify why my Measure is giving me NO even after selecting the current month.
 
ThankYou.
 
Need Help

5 Replies

  • 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.