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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JamesFR06 ,
my whole scenario is setup 2 slicers which each one will affect second one, so if I select one speicific user in slicer, then second slicer (with location values) will be filtered based on previous option.

So my logic is following

Measure = CALCULATETABLE(VALUES(Locations), FILTER(Users,Users[Name] ))
issues is that I cannot create table that will be filtered by second parameter
then I tried to bugfix it one-by-one and see first issue in VALUES(LOCATIONS) then I am not able to display as a single measure, thefore I check documentation and see that result is tabular but error claims that it must be scalar, I dont think so that it is error in PBI and was not founded till now

affectedSlicer = Calculatetable (Cal)

JamesFR06's avatar
JamesFR06
Icon for Resolver IV rankResolver IV
2 years ago

It's automatic, you just have to put the column name in 1 slicer and if relationshios are ok it should be ok

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    unfortunatelly the relation are issue 😞 these are fix , therefore I asked here 😞
    and still dont understand what VALUES return if not tabular 😞

     

    • JamesFR06's avatar
      JamesFR06
      Icon for Resolver IV rankResolver IV
      2 years ago

      Just give me an example of your tables, it would be easier for help

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi JamesFR06 

        Here are pics,
        unfortunatelly this forum doesn t support PBIX files 😞 it could be much easier
        Data Model is here (unfortunatelly if both direction filter will be allowed it will works, but for this usecase I cannot swith it)

         

        current status when I select random USER I see all location (instead of only them that are related to selected user)

        see pict 1


        so goal is to avoid these "restricted combinations"