create hundreds of measures at once // DAX Calculate Measure do calculate group of costs at once?

[Markus_W]

Hello,

I'm still a beginner with Power BI and I hope that someone here can help me.

I created the following measure, which also works perfectly:

1 MS_employee1 =
2 CALCULATE ([total costs],
3 Daten[PersNr]=1900)

I would like to visualize the costs per employee that this employee has caused per month. 1900 is the personnel number of ONE employee. Since I have 375 employees, I now have to create this measure 375 to visualize the personnel costs for each employee.

Is there a DAX formula that I can use to visualize 375 employee costs at once? Not as a sum but individually?

Or

Is there any help on how I can create the measure 375 times, just with a different personnel number?

Thank you in advance for the suppor!

Markus

[nleuck_101 · Accepted solution]

@Markus_W 

You can have all the personnel numbers selected or just add the personnel number to your legend. I will say if you have a lot of personnel numbers visually this will look too messy.

[nleuck_101]

Hello @Markus_W 

Could you just use your total costs measure and add a slicer to your report with the personnel number and select the personnel number you want to see? That way it would only show you the total costs for the personnel number you've selected.

[Markus_W]

Hello nleuck_101

many thanks for the quick reply!

Unfortunately, this does not help me. I want to show in a graph all employee costs at once per employee. All at once!  Like this:

A slicer where I select one of many personnel numbers does not help here.

Best regards

Markus 

[nleuck_101 · Accepted solution]

@Markus_W 

You can have all the personnel numbers selected or just add the personnel number to your legend. I will say if you have a lot of personnel numbers visually this will look too messy.

[Markus_W · Accepted solution]

Hello,

many thanks for the help. Drawing the personnel number in the legend is what I was missing. Don't worry about the many personnel numbers! I will manage them via filters according to departments! 🙂

Best regards
Markus