Forum Discussion

daxreport's avatar
daxreport
Frequent Visitor
3 years ago

Summing a column from a Virtual table

Hello,    In my measure, I have created a Virtual Table using VAR statement. This virtual table uses ALLSELECTED to summarize all the columns available in the current visual along with two measures...
daxreport's avatar
daxreport
Frequent Visitor
3 years ago

Hi Alf94  Thanks for your response.

 

Unfortunately, it is not working as the SUMX iteration is adding up the entire Calculated Table which is using ALLSELECTED.

 

I need to find a way to use current filter context before SUMX conducts its operation of the calculated table. Thanks