cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nataliesmiy1357
Helper II
Helper II

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

 

nataliesmiy1357_0-1638208405910.png

 

 

6 REPLIES 6
Anonymous
Not applicable

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

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.

 

nataliesmiy1357_0-1638281242619.png

 

Anonymous
Not applicable

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

 

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:

nataliesmiy1357_0-1638364933915.png

after:

nataliesmiy1357_1-1638364970739.png

 

nataliesmiy1357
Helper II
Helper II

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

Anonymous
Not applicable

Hi

 

A switch statement would probably work for this?

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.