Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a table for Incidentes and I need to know the amount of tickets by analyst we are having, but we have a few analyst that only log in for special tickets and solve maybe 1 or 2 tickets in a month and are breacking my measure. I try adding a filter but it's not working
Solved! Go to Solution.
@SebastianCostas , try
Assignee cnt = count(ITSM_Incidents[Assignee])
Incidents by Analysts =
VAR Last = max(CreatedDate[Date].[Date])
VAR First = min(CreatedDate[Date].[Date])
VAR QIncidents = CALCULATE(count(ITSM_Incidents[Key]), ITSM_Incidents[Createdwithouthour] >= First , ITSM_Incidents[Createdwithouthour] < Last)
VAR QAnalistas = Countx(FILTER(values(ITSM_Incidents[ITSM_Incidents[Assignee]]), [Assignee cnt ] >100) , ITSM_Incidents[Assignee])
I did an small change to what you sent me and is working perfctly
@SebastianCostas , try
Assignee cnt = count(ITSM_Incidents[Assignee])
Incidents by Analysts =
VAR Last = max(CreatedDate[Date].[Date])
VAR First = min(CreatedDate[Date].[Date])
VAR QIncidents = CALCULATE(count(ITSM_Incidents[Key]), ITSM_Incidents[Createdwithouthour] >= First , ITSM_Incidents[Createdwithouthour] < Last)
VAR QAnalistas = Countx(FILTER(values(ITSM_Incidents[ITSM_Incidents[Assignee]]), [Assignee cnt ] >100) , ITSM_Incidents[Assignee])
I did an small change to what you sent me and is working perfctly
Thank you very much, but i'm having an error with the last var:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
140 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
209 | |
92 | |
64 | |
59 | |
56 |