I need help in converting Qlik sense expression into a DAX expression.
Qlik sense expression:
if(sum(Total <AssociateEmail,RatingManager>{<flag_skill={1}>}RatingManager)>0, 'Initiated', 'Not Initiated')
- AssociateEmail — is from Table A
- RatingManager,flag_skill — is from Table B
1
The DAX expression:
IF(
CALCULATE(
SUM('Table B'[RatingManager]),
'Table B'[flag_skill] = 1,
ALLEXCEPT('Table A', 'Table A'[AssociateEmail])
) > 0,
"Initiated",
"Not Initiated"
)
2