Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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")

     

    amitchandak 

  • Anonymous's avatar
    Anonymous
    4 years ago

     

    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" ) ...

     

    ValtteriN 

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

 

Wherever I have put 'Table' in my measure or column, change "Table" to your table name.

 

For the Measure, you don't need to worry about the column names, only the Table name. 

 

Hope this helps.

Theo

 

PS take a screenshot of the issues with your output and I can try assist from that.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi TheoC 

Please see snip below:
Edgar, Ila is one of those employees is both a casual and adjunct instructor, hence she should appear as "Yes"

But when I generated the measure and calculated column using the query you gave me, here is  what I see:

NB: Measure on the table is the measure I generated with your query
Column is also the calculated column I generated with the query you gave me

 

Please advise. Thanks.

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous 

     

    Sorry mate. I didn't realise you wanted to filter using slicers.  Adjust the MEASURE to the following please and your output will be what you're after. We just need to add a CALCULATE and FILTER ALL to it like follows:

     

    Measure = 
    VAR _1 = COUNTROWS ( 'Table' )
    VAR _2 = CALCULATE ( SWITCH ( TRUE() , _1 < 2 , "No" , "Yes" ) , ALL ('Table' ) )
    RETURN
    _2

    All the best with the journey!

    Theo 🙂