Forum Discussion
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 ...
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.
Try this? (My columns are purely examples.)
TestMeasure =
VAR limit = MAX('Chapters'[Chapter ID])
RETURN
IF (COUNT(Characters[Character Name])>=limit,"YES","NO")
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: