Using a variable to set part number, Sum issue

[#1]

Hi all,

Still a novice to this so this may be a very basic question.

I have set a variable as follows ,

FirstSortedValue([Part Number], -Aggr(sum({$<Week={$(=max(Week))},eTailer-={specified etailer name}>}[Total Events]),[Part Number]))

(That works fine to display the Part Number)

and referenced it in a text box to try to count the number of clicks (Total Events) this part had last week (This is for a dashboard view btw) as follows:

=sum({<[Part Number]={$(vTopPartLastWeek)}>}[Total Events]) 

But I cannot make this work, can anyone please tell me where I've gone wrong here?

[marcus_sommer · Accepted solution]

Try this:

=sum({<[Part Number]={'$(vTopPartLastWeek)'}>}[Total Events])

- Marcus

[#3]

Thank you SOOO much Marcus!!

This works a treat.