Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 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")
) )
That DAX formula looks good, have you encountered any problem?
@kafil10 wrote:
I need to get it automatically with the filter pane you know !!
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.
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")
) )
User | Count |
---|---|
15 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |