Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kafil10
Frequent Visitor

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 (
            ALLSELECTED(ENPS);
            ENPS[NewColumn.RecvdDate] <= [Date]
                && (
                   ENPS[NewColumn.ClosedDate] > [Date]
                        || ISBLANK ( ENPS[NewColumn.ClosedDate] )
                )
        && (ENPS[GroupName]="ENPS EMEA IT Helpdesk")
    ) )

 

5 REPLIES 5
Eric_Zhang
Employee
Employee


@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?

@Eric_Zhang

 

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


@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.

@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.

group_name.jpg

kafil10
Frequent Visitor

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.