How to make a new measure for specific item name and its value

[cmllrcg]

Hello,

Appreciate your time looking into this post. I am fairly new to Power BI and would really appreciate the input.

The Accumulator ID that I want is '30' and its corresponding value.

The measure would be called "CPH", I was wondering if its possible to filter out just the AccumulatorID no. 30 and its value in a single measure.

Table name is Accumulators

Thanks in advance!

[Anonymous · Accepted solution]

CPH =
CALCULATE (
MAX ( 'Table'[Value] ),
FILTER ( 'Table', 'Table'[Accumulator ID] = 30 )
)


Replace MAX with MIN to find the minimum value from the Value column. Works?

[Anonymous]

How the output should look like?

[cmllrcg]

Hey, thanks for taking the time.

It should just output the "Value" of the AccumulatorID no. 30