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

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

Reply
SebastianCostas
Frequent Visitor

Distinct Count only when Count over a number

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

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 = CALCULATE(DISTINCTCOUNT(ITSM_Incidents[Assignee]),FILTER(ITSM_Incidents,count(ITSM_Incidents[Assignee])>100))


return QIncidents / QAnalistas
2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

I did an small change to what you sent me and is working perfctly

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[Assignee]),[Assigne cnt]>100),ITSM_Incidents[Assignee])

return QIncidents / QAnalistas

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I did an small change to what you sent me and is working perfctly

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[Assignee]),[Assigne cnt]>100),ITSM_Incidents[Assignee])

return QIncidents / QAnalistas

Thank you very much, but i'm having an error with the last var:

SebastianCostas_0-1659105300699.png

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!