Forum Discussion

yasbos's avatar
yasbos
Resolver II
2 years ago

Allselected doesn't work on a table variable

Hi. I have a table variable consisting of  var TotalTime= ADDCOLUMNS(                 summarize(Tbl1 ,Tbl1[ID])                 , "Duration"                 ,calculate(                        ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi yasbos ,

 

I can't understand you clearly, but I made some attempts. The unique value case you are talking about is misplaced measure.

T1 ALL = CALCULATE(SUMX('T1','T1'[value]),ALLSELECTED('T1'[ID]))

VT ALL = CALCULATE(SUMX('VT','VT'[Duration]),ALLSELECTED('VT'[ID]))

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • yasbos's avatar
    yasbos
    Resolver II
    2 years ago

    Thanks for trying, Anonymous . I see you created a calculated table. I can't create calculated tables because I aork with an analysis services tabular model. I can't create columns or calculated tables. However, my question is specific to table variables that are created within the measure for use within the measure only. What I'm sayin is that, it seems that allselected does not work on table variables. The code works fine if I doen't use table variables. My question was whether I was not doing it correctly, and if there is a way to be able to use allselected on a table variable. Thanks.