Power BI MIN IF DAX Function

Question

I have a table in Power BI as below, and I need to calculate which record has the minimum value based on the if condition.

Country	People count
France	20
USA	15
England	30

In the above table, if the value matches with the min value it displays the true value in a new column else it displays the false value.

The expected output should be like this table, If the country has the lowest value show true otherwise show false

Country	People Count	Rate
France	20	false
USA	15	true
England	30	false

How can I use the IF condition with MIN() DAX function in Power BI?

Answer 1

First, you should be aware that there is no IF MIN() function in Dax, Instead, you can quickly get the smallest value based on a condition using the below formula:

MINIF = IF('Employee Degree'[Degree] = min('Employee Degree'[Degree]),"Lowest","Not Lowest")

Output

Another way to get the Minimum value with IF condition is to define a variable as shown below:

IFMIN = 
 VAR LowDegree = MIN('Employee Degree'[Degree])
      RETURN
IF('Employee Degree'[Degree] = LowDegree,"Lowest","Not Lowest")

Output

Check also many of Power BI DAX samples at https://github.com/melqassas/PowerBI