Forum Discussion
Creating Column... Circular Dependecy
I am importing a table TABLEA from AAS direct query connection. Lets say TABLEA has two columns... Location Sales I want to add a new column called "Location Sales Total" which sums the S...
spencerhoyle10 , I doubt you can create a column like this in direct query
Try a measure like
CALCULATE(SUM(TABLEA[Sales]), FILTER(allselected(TABLEA), TABLEA[Location] = max( TABLEA[Location]) ))