Forum Discussion
Reg: Calculation
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?
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.