Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |