topic Finding the minimum value for each row IF the two conditions are TRUE in DAX Commands and Tips

Finding the minimum value for each row IF the two conditions are TRUE

calexander1337 — Wed, 19 Jun 2019 16:26:05 GMT

Hey everyone, I'm trying to find a way to create a custom column that allows me to find the minimum value of each row if the conditions in two other columns are true.

To put some clarity, I have a field named QuantityNeeded that I am trying to find the minimum of. I want to find the minimum for every row in QuantityNeeded whenever the field Required? is "Optional" AND whenever the field CompetencyType is "Exams."

I tried writing a DAX formula to solve this problem, but I'm unfamiliar with complex DAX solutions. Below is the DAX that I wrote:

Minimum Needed = IF('CompetencyRequirements'[CompetencyType]="Exams" && 'CompetencyRequirements'[Required?]="Optional", MINX(FILTER(CompetencyRequirements, [CompetencyType]="Exams"), FILTER(CompetencyRequirements, [Required?]="Optional")) ,BLANK())

All fields are within the same table, CompetencyRequirements, and the error I'm getting is: "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." All I want to do is find the minimum of one column, QuantityNeeded, when the conditions of the other two columns are true. I appreciate any and all help!!

Re: Finding the minimum value for each row IF the two conditions are TRUE

parry2k — Wed, 19 Jun 2019 17:41:47 GMT

calexander1337 Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: Finding the minimum value for each row IF the two conditions are TRUE

avanderschilden — Wed, 19 Jun 2019 18:10:28 GMT

Hello,

What about this?

Re: Finding the minimum value for each row IF the two conditions are TRUE

calexander1337 — Wed, 19 Jun 2019 18:40:04 GMT

Hi! Thanks for your response. This is a solution to the problem I presented, so I'll mark it as the solution. Although, I realized I left out minor details in this post that make the problem more complex. Regardless, this problem ended up getting solved internally, but I appreciate the effort you put into answering!

avanderschilden wrote:
Hello,

What about this?