Value is not showing at set analysis

[#1]

Hello Everyone,

Can you please help in this

i used set like below, expression is ok, but not getting any values

=sum({<Year_No={$(vYear)},Manager={'Harsha'}>}[Revenue])

any one please correct me if i wrote wrong syntax

Thanks

[#2]

Not working sorry

[jagan]

Hi,

Check the variable vYear value by putting in Text Object and check whether you have data for the variable value.  Try below expressions

=sum({<Year_No={$(=vYear)},Manager={'Harsha'}>}[Revenue])

Or

=sum({<Year_No={'$(=vYear)'},Manager={'Harsha'}>}[Revenue])

Regards,

Jagan.

[sudeepkm]

if possible then can you pls post the qvw ?

[rubenmarin]

Maybe you need to check values before continue:

- in a text box check the return for =vYear

- in a straight table with dimensions Manager and Year_No the expression Sum([Revenue])

Select manager Harsha and check the revenue when Year_No=vYear

[#6]

i can't post the qvw, since it is huge and having client information

[#7]

values are there i checked it, association also there between

[#8]

Hi,

Try,  sum({$<Year_No={$(#vYear)},Manager={'Harsha'}>}[Revenue])

[sudeepkm]

then it should have worked unless there are some spelling mistakes.

Can you please post screenshot of your chart and tell us what you see in the expression? like below.

do you see any value for Year_No in your chart. like in the attached screenshot the value is 2012.