Forum Discussion

NJ81858's avatar
NJ81858
Helper IV
2 years ago
Solved

DAX Measure for KPI Target Value

Hello,

 

I am trying to create a KPI visual that tracks a value over time compared to the value on the first date. I am trying to have my Target Value be the value on the first date, and the measure that I currently have is not quite working. The measure that I currently have is:

First Value = CALCULATE(SUM('Table'[Balance]), FILTER('Table', [Date] = MIN('Table'[Date])))

 

What the measure is doing currently is just using the most recent value, rather than the first value no matter what.

 

Any help would be greatly appreciated. Thank you in advance!

Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, NJ81858 

     

    You can try the following formula.

    First Value =
CALCULATE ( SUM ( 'Table'[Balance] ),
    FILTER ( ALL ( 'Table' ),
        [Date] = CALCULATE ( MIN ( 'Table'[Date] ), ALL ( 'Table' ) )
    )
)

     

    Best Regards,

    Community Support Team _Charlotte

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

     

2 Replies

  • mlsx4's avatar
    mlsx4
    Memorable Member
    2 years ago

    Hi NJ81858 

     

    I think that you should use ALL inside the filter:

     

    First Value = CALCULATE(SUM('Table'[Balance]), FILTER(ALL('Table'), [Date] = MIN('Table'[Date])))
  • v-zhangti's avatar
    v-zhangti
    Community Support
    2 years ago

    Hi, NJ81858 

     

    You can try the following formula.

    First Value =
CALCULATE ( SUM ( 'Table'[Balance] ),
    FILTER ( ALL ( 'Table' ),
        [Date] = CALCULATE ( MIN ( 'Table'[Date] ), ALL ( 'Table' ) )
    )
)

     

    Best Regards,

    Community Support Team _Charlotte

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