Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Countrows for specific values (where more values are possible)

Hi, I am working on a report where I need to make a count of people (persons) that only are using 2 specific roles. However, a person can be using more roles and I am only interested in those 2 "uni...
  • Anonymous's avatar
    Anonymous
    4 years ago

    So I am actually using it know, I am new to this, so .... but I am using it the other way around (I have turned the roles around). Thanks a lot.

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

You can use a calc column:

A B Roles = IF(OR(OR('Table'[Roles] = "A/B",'Table'[Roles] = "A"),'Table'[Roles] = "B"), 1,BLANK())

I hope this helps!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, Thanks a lot for the quick response. Sounds like an intersting idea. However in the result (table) I also get users with both e.g. role A and D. Any idea why? So I need very explicit, based on a long list with persons, to filter out all those with more roles that A and B.

    • Whitewater100's avatar
      Whitewater100
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Hi:

      If you only want A or B and not A/B combined, then you can use this calculated column.

      A B Roles Only = IF(OR('Table'[Roles] = "A",'Table'[Roles] = "B"), 1,BLANK())
      I'll paste image below. Can you please mark as solved? Thanks...

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi,

        Result seems to be the same, I still get users with other roles (activities) in the list, it does not seem to produce a list with the As or Bs only. I can close it, but maybe someone else knows a trick for this?