The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Solved! Go to Solution.
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.
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.
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])))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
240 | |
125 | |
122 | |
82 | |
80 |