Forum Discussion

Seven440's avatar
Seven440
Regular Visitor
7 years ago

Get column values from table

Hi all!   The task seems simple, but search in forums and DAX guide didn't help me. There is the only table Sales with several columns (Item, Store, Area, Month, Flag1, Flag2, Value). I try to ad...
Seven440's avatar
Seven440
Regular Visitor
7 years ago

SteveCampbell

thanks, the first example seems what I was looking for, but now the error appears: 

"The function expects a table expression for argument '2', but a string or numeric expression was used."

 

If I use your example without condition on Sales[Store], there are no errors. So, as I can judge, the point is about using IN here.

Do you have an idea how to fix it?

SteveCampbell's avatar
SteveCampbell
Icon for Memorable Member rankMemorable Member
7 years ago

yep, made an error - should have been CALCULATETABLE not CALCULATE.

 

Updated the code, try now

  • Seven440's avatar
    Seven440
    Regular Visitor
    7 years ago

    SteveCampbell 

    Now the next error appears:

    A circular dependency was detected: 'Sales'[Filtered_value],'Sales'[Filtered_value],'Sales'[Filtered_value].

     

    'Sales'[Filtered_value] is the resulting column (where I use the updated formula).

     

    Please help.