Reachni the text field from filter

[kafil10]

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")
    ) )

[Eric_Zhang]

---

@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")
    ) )

---

@kafil10

That DAX formula looks good, have you encountered any problem?

[kafil10]

@Eric_Zhang

I need to get it automatically with the filter pane you know !!

[Eric_Zhang]

---

@kafil10 wrote:

@Eric_Zhang

I need to get it automatically with the filter pane you know !!

---

@kafil10

What do you mean "get it with the filter pane"? The filter applied in DAX won't reflect in the filter panel.

[kafil10]

@Eric_Zhang



what i want man is when i chek the group name like this it will change the graph above with rectifying the formula.

[kafil10]

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")
    ) )