Reg: Calculation

[jananagarajan]

I have  written a  Tableau LOD Calculation and would like to replicate the same in Power BI using DAX. 

{ FIXED [ID] : MIN(

IF [Temp] >= 0 AND [Temp] <= 32.5 THEN [Value]

END

)}

Can any one help me in writing the same calculation in powerbi?

[v-yanjiang-msft · Accepted solution]

Hi @jananagarajan ,

Based on my understanding, you want to get the minmum Value in the filtered table where Temp >=0 and <=32.5.

I create a sample.

The minimum value that meets the criteria is 2. Here's my solution, create a measure.

Measure =
MINX (
    FILTER ( 'Table', 'Table'[Temp] >= 0 && 'Table'[Temp] <= 32.5 ),
    'Table'[Value]
)

Get the result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.