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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Milozebre
Helper V
Helper V

Calculate results with filters

Good morning PBI Community 🙂

 

Hope that everything is okay Smiley Happy

 

I have a little problem.

I explain to you.
I have people who have done troubleshooting. Here is an example of extraction of the different fields.

 

Table 'Dossierscrées'

Field : Date, Numdossier, intervenant, equipeExample.jpg

 


These people are part of teams.
When I choose a date range, how do I determine how many people have done troubleshooting?

The answer in thios case : 10 10 differents employees
I tried to do it through filters, or boxes but I find extravagant results.
I assume that a measure would be adequate, but I do not know how to start
Thank you for your help.

1 ACCEPTED SOLUTION
Eric_Zhang
Employee
Employee


@Milozebre wrote:

Good morning PBI Community 🙂

 

Hope that everything is okay Smiley Happy

 

I have a little problem.

I explain to you.
I have people who have done troubleshooting. Here is an example of extraction of the different fields.

 

Table 'Dossierscrées'

Field : Date, Numdossier, intervenant, equipeExample.jpg

 


These people are part of teams.
When I choose a date range, how do I determine how many people have done troubleshooting?

The answer in thios case : 10 10 differents employees
I tried to do it through filters, or boxes but I find extravagant results.
I assume that a measure would be adequate, but I do not know how to start
Thank you for your help.


Where do you apply the measure? To count different employees, I think you can create a measure like 

employees = DISTINCTCOUNT('Dossierscrées'[nomprenomcreepar])

 

View solution in original post

2 REPLIES 2
Eric_Zhang
Employee
Employee


@Milozebre wrote:

Good morning PBI Community 🙂

 

Hope that everything is okay Smiley Happy

 

I have a little problem.

I explain to you.
I have people who have done troubleshooting. Here is an example of extraction of the different fields.

 

Table 'Dossierscrées'

Field : Date, Numdossier, intervenant, equipeExample.jpg

 


These people are part of teams.
When I choose a date range, how do I determine how many people have done troubleshooting?

The answer in thios case : 10 10 differents employees
I tried to do it through filters, or boxes but I find extravagant results.
I assume that a measure would be adequate, but I do not know how to start
Thank you for your help.


Where do you apply the measure? To count different employees, I think you can create a measure like 

employees = DISTINCTCOUNT('Dossierscrées'[nomprenomcreepar])

 

@Eric_Zhang : Thank you for your help.

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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