Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Selected value does not work

Hello every one,   I want to make a ytd and p-ytd report, via a selection from a slicer the user would see the offers in the selected year and the offers in the selected year -1. I wrote the measu...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Seems you forgot to put the "- 1" after "x".
    Also you cannot calculate a variable inside CALCULATE

     

    Offers_selYear =
VAR x =
    SELECTEDVALUE ( 'Query1'[year] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( Query1[offerid] ),
        Query1[Type] = "Offers",
        Query1[year] = x - 1
    )

     

     

     

     

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
Seems you forgot to put the "- 1" after "x".
Also you cannot calculate a variable inside CALCULATE

 

Offers_selYear =
VAR x =
    SELECTEDVALUE ( 'Query1'[year] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( Query1[offerid] ),
        Query1[Type] = "Offers",
        Query1[year] = x - 1
    )