Forum Discussion
Using a new column, compile a yes or no value for column A based on values in Column B
Hi Everyone, I need to generate a new column in my report using DAX. This new column should contain a yes or no values for Column A based on the values in Column B. For clarity and with refer...
Try new column
new column =
var _cnt = calculate(distinctCOUNT(Table[Position]), Filter(Table, [Employee names] = earlier([Employee names]) && Table[Position] in {"Casual instructor", "Adjunct Instructor"} ))
return
if( not(isbalnk(_cnt)) && _cnt =2, "Yes", "No")Another Solution:
Hi, Here is an example on how to do this: Positions = var inspect = Inspector[Name] return If ( COUNTROWS ( FILTER ( ALL ( Inspector ), Inspector[Name] = inspect &&( Inspector[Position] = "A" || Inspector[Position] = "B" )))= 2 , "Yes" , "No" ) ...
TheoC
Community Champion
Community ChampionHi Anonymous
You can use the following measure:
Measure =
VAR _1 = COUNTROWS ( 'Table' )
RETURN
SWITCH (
TRUE() ,
_1 < 2 , "No" ,
"Yes" )
Output is per below:
Hope this helps 🙂
Theo