When you ants to create a new measure like count or distinct count with some multiple filters.
CALCULATE ( COUNT ( X , FILTER(Exp1, Exp2, ...)))
CALCULATE ( DISTINCTCOUNT ( X , FILTER(Exp1, Exp2, ...)))
Check the below example..
CALCULATE (DISTINCTCOUNT (WC_ASSAI_TRANSMITTAL_F[DOCS_SEQ_NR]),FILTER(WC_ASSAI_TRANSMITTAL_F,WC_ASSAI_TRANSMITTAL_F[FLAG]="Y" && WC_ASSAI_TRANSMITTAL_F[RETURN_DATE] = BLANK() && WC_ASSAI_TRANSMITTAL_F[RESPONSIBLE_ENGINEER_IND]="Y" && WC_ASSAI_TRANSMITTAL_F[DUE_DATE]< TODAY() ))
No comments:
Post a Comment