Creating a custom formula

[nataliesmiy1357]

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!!

[Anonymous]

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]

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]

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")

[nataliesmiy1357]

So this worked I think this worked.... but now when I put it into my table, it gets rid of my filters and shows more rows than normal.... 

before:

after:

[nataliesmiy1357]

I'm not sure what a switch statement is.... how would I write that?

[Anonymous]

Hi

A switch statement would probably work for this?