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
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

have you tried the switch statement?

 

something to the effect off

 

switch(true(),

          and (ismembergroupA = 1, ismembergroupb = 0), "Result",

      and (ismembergroupA = 0, ismembergroupb = 1), "Result",

      "Other Result")

 

 

 

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?