set analysis help

[#1]

Can i use the below expression ?

sum({<TM>}[Square Feet])

here both  TM and [Square Feet]  are columns.

[avinashelite]

based on the selection of TM your sum of square Feet will get calculated ...

sum({<TM>}[Square Feet])

will give the total sum and it will not change according to the TM selection

sum([Square Feet])

this will give the total sum and it will vary according to the TM selection

i.e if

TM a has value 10 and b has values 20

then first expression when you select a or b it will always show the sum as 30

but if you go with second expression and if you make a as the selection in TM then sum will be 10..

Hope you got the difference

[sasiparupudi1]

sum({<TM={*}>}[Square Feet])

[#4]

THIS EXPRESSION SHOWS ERROR

[sasiparupudi1 · Accepted solution]

sorry

sum({<TM={'*'}>}[Square Feet])

[avinashelite]

Did you check the explanation below

[#7]

I had to put the colon for the *.So,no error msg now.

sum({<TM={'*'}>}[Square Feet])

Thank you.It worked for me.Even with the error msg the answer was right.Thank you.

[#8]

Thank you very much for your help.I appreciate it.

[sunny_talwar]

Just to add, I think this should also work:

=Sum({<TM=>}[Square Feet])

[#10]

Ya,that did work but was showing and error line.But the answer was correct.