Forum Discussion

BSM1985's avatar
BSM1985
Icon for Helper IV rankHelper IV
5 years ago
Solved

Boolean Output using Calculated Measure

Hi Team,   Below is my data set. I have 2 calculated measures. Please advice how to achieve CALCULATED MEASURE 2 CALCULATED MEASURE 1:  Max of COLUMN C by COLUMN A and COLUMN B   CALCULATED MEA...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    BSM1985 

    can we create two columns for this?

    Column = CALCULATE(MAX('Table'[C]),ALLEXCEPT('Table','Table'[A],'Table'[B]))

Column 2 = if('Table'[C]='Table'[Column],True,FALSE)

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

BSM1985 

Here are the 2 measures 

 

Measure 1 = 

CALCULATE(
    MAX('Table'[COLUMN C]),
    ALLEXCEPT('Table','Table'[COLUMN A],'Table'[COLUMN B])
)
Measure 2 = 
IF(
    MAX('Table'[COLUMN C] ) = [Measure 1],
    TRUE(),
    FALSE()
)

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn