Conditional measure

[UsePowerBI]

Hello

I have a Measure like:

Measure=MAX([Value])

For the data:

Product,Value,Date

A, 1, Date1

B, 2, Date1

A, 3, Date1

I want for every date, when Product=A to return MAX([Value]) and when Product=B to return MAX(([Value])/100

However, when I try to create a Measure like this and use IF, it does not offer me to use a Column but only other Measures. Any idea?

Thanks!

[v-eqin-msft]

Hi @UsePowerBI ,

Could you tell me if your problem has been solved by @themistoklis 's suggestion? If it is, kindly Accept it as the solution to make this thread closed. More people will benefit from it. Or you are still confused about it, please show me your expected output.

Best Regards,
Eyelyn Qin

[themistoklis · Accepted solution]

@UsePowerBI 

Try the following formula. Also attached a workspace.

Column = If(Sheet1[Product] = "A",CALCULATE (
    MAX ( Sheet1[Value]),
    ALLEXCEPT ( Sheet1, Sheet1[Date] )
),
CALCULATE (
    MAX ( Sheet1[Value]),
    ALLEXCEPT ( Sheet1, Sheet1[Date] )
) /100
)