Wednesday, 11 November 2020

POWER BI - DAX - New Measure ( Distinct Count with Multiple Filters )

 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

Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps. 1. Open Report Query Editor Mode. 2. Clink on Get Data -> Blank...