Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

function Values doesn t return Table of values but error

Hi,   I want to use VALUES function and study from https://dax.guide/values/ that input is table/column and output table (one or more columns) I tried to od it on most simplest case but it failed,...
DAX
error
values
JamesFR06's avatar
JamesFR06
Icon for Resolver IV rankResolver IV
2 years ago

Hi

With a measure you can return only a unique value

Values will not work because it return a list of unique values of the column.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello JamesFR06 ,

thanks for input !
but in documentation is written that it returns table/tabular and not scalar, therefore I am confused

 

I also tried to use it in CALCULATE(VALUES(Locations))  and also it is not working, so I am confused again 😄

 

issue is definitively somewhere in my code

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    JamesFR06I also tried CALCULATETABLE(VALUES(Locations)) and doesn t any output