Hi all,
Using Excel 2013.
Trying to create a Calculated Column in a table to put Expense in 1 of 4 categories
I came up with
=CALCULATE(sum([TotalExpense]),FILTER(factExpense,factExpense[ExpnseType]="Sundries"))
But that is returning total instead of a total for each record
What did I miss?
This works for the first Calculated column:
=CALCULATE(sum([TotalExpense]),FILTER(dimExpense,dimExpense[Type]="Sundries"))
But as soon as I copy the formula to the next column and update the type to "Wines_Spirits" I get
Found the answer on SQLBI websiteA circular dependency was detected
I added a unique id to each row and in Table Behavior in the Data Model set the Unique_ID as the Row_Identifier
Works great!
Link: http://sqlblog.com/blogs/alberto_fer...es-in-dax.aspx
thx
w
Bookmarks