Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Helper IV
4 years ago

Creating a custom formula

Hello!  I am not sure how to go about the dax formula that I want to make...

 

I want to make a formula, that does this:

 

Takes the minimum no. of TMs, and if that number of people in the table above have a 3 or above, then it's a yes, and if not, it's no.  

 

So in this screenshot, I need 4 people to have a score of 3 or above.  and because none of them do, the answer would be no.

 

So the tables with the entities are:

tablea[score] - which values are 0-4

tableb[numberOfTMs]

 

Please let me know if you can help!!

 

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi

     

    A switch statement would probably work for this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Sorry, I think an IF statment will be what you are looking for. 

     

    It will be something like this: IF(tableb[numberOfTMs]) => 3, "YES","NO")

    • nataliesmiy1357's avatar
      nataliesmiy1357
      Helper IV
      4 years ago

      okay.... When I try to type that in, I can't bring in some of the values.  Attached is my entities.  (Proficiency number is my number of team members)

       

      I was going to type in: IF ( count(employeeName) >= proficiencyNu, 'YES', 'NO')

       

      But it won't let me bring in proficiency number.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi nataliesmiy1357 

         

        Try this? (My columns are purely examples.)

         

        TestMeasure = 
VAR limit = MAX('Chapters'[Chapter ID])

RETURN
    IF (COUNT(Characters[Character Name])>=limit,"YES","NO")