Sum of Stacked Bar Chart

[Anonymous]

Hi

I was wondering if there was an easy way to sum the measures displayed in a stacked bar chart

My formula to find "LeaksPerDay" is

LeaksPerDay = count('Crew Productivity'[WR#])/distinctCOUNT('Crew Productivity'[Date])

There are 15 crews

Is there any way to simply add the total of LeaksPerDay (which is 21.35) and divide this by the distinct crews (which is 15) to get 1.42?

Thank you!
Sarah

[amitchandak]

Something like this?

divide([LeaksPerDay],distinctCOUNT('Crew Productivity'[ID]))

[Anonymous]

hi @amitchandak !

is there any way to sum the measure [leaksperday]?
If I could do this, then this formula may work...

Thank you!
Sarah

[amitchandak]

Try like.

sumx(summarize('Crew Productivity','Crew Productivity'[Date],"_leak",[LeaksPerDay]),[_leak])

Can you share sample data and sample output.

Appreciate your Kudos.