Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional measure

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!

Need Help
  • themistoklis's avatar
    themistoklis
    4 years ago

    Anonymous 

     

    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
)

2 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    4 years ago

    Anonymous 

     

    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
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    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