Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
nataliesmiy1357
Helper III
Helper III

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 III
Helper III

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.