cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## How can I obtain the minimum value from my measure

Hello,

I have a dashboard in which I want to determine the difference from a high water mark of running totals form a set of values.

I have three measures:

1. Running Total, this calculates the running total of the values in date order.

``````Running Total =
CALCULATE (
SUM(Data[Value]),
FILTER ( ALLSELECTED(Data), Data[Index] <= MAX ( Data[Index] ) )
)``````

2. High Water Mark, this calculates the highest value the Running Total has reached so far.

``````High Water Mark =
MAXX (
FILTER ( ALLSELECTED( 'Data' ), Data[Index] <= MAX ( Data[Index] ) ),
"Running Total", [Running Total]
),
[Running Total]
)``````

3. Difference from High Water Mark, this calculates the difference between the High Water Mark and the Running Total.

``Difference from High Water Mark = [Running Total] - [High Water Mark]``

I want to be able to capture the minimum value of the Difference from High Water Mark which would be -226 but I am unable to do so as the MIN() function cannot be used against a measure.

Can anyone help me on how I can obtain this minimum value?

MY PBIX file can be downloaded from this wetransfer link...PBIX file

Any help you can offer is appreciated.

Kind regards,

Neil

1 ACCEPTED SOLUTION
Super User

 Expertise = List.Accumulate(        {Days as from Today},        {Skills and Knowledge},        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday))

4 REPLIES 4
Super User

 Expertise = List.Accumulate(        {Days as from Today},        {Skills and Knowledge},        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday))

Frequent Visitor

I appreciate the help and the resolution of my problem.

Neil

Super User

@Burtoninlondon

You can follow the below syntax

You can find the file here

Please find the other formula where I calculated the min value till the current row.

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

Frequent Visitor

@tharunkumarRTK, thanks for your response, it was very helpful.

I'm going to mark the other response from @ThxAlot as the solution as it needed less measures in my model.

Neil

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.