Forum Discussion

jananagarajan's avatar
jananagarajan
Regular Visitor
3 years ago
Solved

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 on...
Need Help
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

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.