Forum Discussion

sunah132's avatar
sunah132
Helper I
5 years ago
Solved

Sum up minimum value and 0 value

Hello,  I'm working on this power BI Matrix and not sure about this step forward. I have brought minimum values of each region's rate based on their dates. I used the formula of SWITCH ( TRUE (), ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi sunah132 

     

    You could try this measure:

    Measure_Value = 
IF (
    ISINSCOPE ( 'Table'[Route] ) && ISINSCOPE ( 'Table'[Date] ),
    MIN ( 'Table'[Value] ),
    SUM ( 'Table'[Value] )
)

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

amitchandak's avatar
amitchandak
Super User
5 years ago

sunah132 , Try like this once

SUMX ( VALUES ( 'Table'[Date] ),calculate( MIN ( 'Table'[Value] ) ))