Forum Discussion
Solved
Add column whose value depends on two other columns
I have a column called ID and another called Status. I want to create a new column called NEW COL. If Status = "Yes" for any of the rows with the same ID then the NEW COL = "Yes" for those r...
Give this a try.
New Status = VAR _Yes = CALCULATE(COUNTROWS(VALUES('Table'[ID])),'Table'[Status]="Yes",ALLEXCEPT('Table','Table'[ID])) VAR _Partial = CALCULATE(COUNTROWS(VALUES('Table'[ID])),'Table'[Status]="Partial",ALLEXCEPT('Table','Table'[ID])) RETURN SWITCH( TRUE(), _Yes > 0, "Yes", _Partial > 0, "Partial", "No" )
Give this a try.
New Status =
VAR _Yes = CALCULATE(COUNTROWS(VALUES('Table'[ID])),'Table'[Status]="Yes",ALLEXCEPT('Table','Table'[ID]))
VAR _Partial = CALCULATE(COUNTROWS(VALUES('Table'[ID])),'Table'[Status]="Partial",ALLEXCEPT('Table','Table'[ID]))
RETURN
SWITCH(
TRUE(),
_Yes > 0, "Yes",
_Partial > 0, "Partial",
"No"
)
Hey jdbuchanan71 , thanks again for your solution.
As an add-on to the above, how could I have this column (or measure) respond to a slicer.
I posted this question here:
Add column whose value depends on two other column... - Microsoft Power BI Community