Forum Discussion

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

Manipulating column on USERPRINCIPALNAME()

Hi all,   I want to make something like this:   TABLE: Field 1 Field 2 Field 3   This table must have a Field 4 which contains Field 1 if the logged in person is in Active Directory Group 'G...
Need Help
MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

That gives an error that I've already got and what makes clear that I'm not familiar enough with DAX... It gives:

 

A single value for column 'IsGroupA' in table 'member groups' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

can i see your dax code with an example of the data

  • MiKeZZa's avatar
    MiKeZZa
    Post Patron
    9 years ago

    We've mailed and Vanessas solution is to combine everything in 1 table. A solution that absolute will work, but not what I'm looking for...

     

    I'm afraid I'm looking for something that is not possible....

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      9 years ago

      out of curiosity why does combining the tables not work for you?

      • MiKeZZa's avatar
        MiKeZZa
        Post Patron
        9 years ago

        I think it will work, but it's not what I was hoping for. This gives me 2 'facttables', only for something easy (in other languages/tools) as this:

         

        if (username IN (list of people that are manager)
{
           FieldA
}
else
{
           FieldB
}

        So I'm still hoping to solve it another way, that is also easier to understand for other people at a later moment....