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 measure bellow but doesnot work.

Offers_selYear =


VAR o =CALCULATE(DISTINCTCOUNT(Query1[offerid]),Query1[Type]="Offers")
VAR x = SELECTEDVALUE('Query1'[year])
RETURN
CALCULATE(
o,
FILTER(all(Query1), Query1[year] = x )
)
 
Thanks in andvace
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
    )

     

     

     

     

     

1 Reply

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