Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dax measure using table and columns

Hi everyone,

I'm making a measure to summarize it into a matrix table. 

 

The measure that I want to do is to create the fourth column (Attending result) that shows a message "present" if one letter from column A has code as Control and other codes (A1, A5...) from column B and the same package from column C; and I would show also "no present" if one letter from column A has only code as Control from column B and the same package from column C.           

Column A and B are from the same table (Table 1) and column C is from (Table 2).            

In column C  we have the same package for this example but it can changes.

 

Thank you for your response. Best regards. 

      

89456.PNG

 

Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Try the below.

     

    Measure = 
VAR _tbl = ALLEXCEPT( 'Table', 'Table'[Column A], 'Table'[Column C] )
VAR _isControl = 
    CALCULATE( 
        COUNTROWS( 'Table' ), 
        'Table'[Column B] = "Control",
        _tbl 
    ) > 0
VAR _isNotControl = 
    CALCULATE( 
        COUNTROWS( 'Table' ), 
        NOT 'Table'[Column B] = "Control",
        _tbl 
    ) > 0
RETURN IF( _isNotControl && _isControl, "Present", "Not present" )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

1 Reply

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

     

    Try the below.

     

    Measure = 
VAR _tbl = ALLEXCEPT( 'Table', 'Table'[Column A], 'Table'[Column C] )
VAR _isControl = 
    CALCULATE( 
        COUNTROWS( 'Table' ), 
        'Table'[Column B] = "Control",
        _tbl 
    ) > 0
VAR _isNotControl = 
    CALCULATE( 
        COUNTROWS( 'Table' ), 
        NOT 'Table'[Column B] = "Control",
        _tbl 
    ) > 0
RETURN IF( _isNotControl && _isControl, "Present", "Not present" )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski