Forum Discussion

Frequent Visitor

9 years ago

Reachni the text field from filter

Hi, i wanna get the text in group name automatically with a filter groupname , there is way guys ?? IThelpdesk = CALCULATE ( COUNT ( ENPS[CallID] ); FILTER ( ALLS...

Need Help

Eric_Zhang

Microsoft Employee

9 years ago

kafil10 wrote:

Hi,

i wanna get the text in group name automatically with a filter groupname , there is way guys ??

IThelpdesk = CALCULATE (
        COUNT ( ENPS[CallID] );
        FILTER (
            ALLSELECTED(ENPS);
            ENPS[NewColumn.RecvdDate] <= [Date]
                && (
                   ENPS[NewColumn.ClosedDate] > [Date]
                        || ISBLANK ( ENPS[NewColumn.ClosedDate] )
                )
        && (ENPS[GroupName]="ENPS EMEA IT Helpdesk")
    ) )