Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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" )
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" )
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |