Measure help

[Anonymous]

Hello!

I'm trying to make a measure that counts the average of my driving index and then counts +1 every time an average between 80-100 occurs.

Averages = SUM(YhdistettyTaulu[drivingindex]) / COUNTX(YhdistettyTaulu;[drivingindex])

(This is my average driving index calculation so far).

Here's an example made by Excel what I'm trying to achieve. The axis should have numbers from 80 to 100.

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

On Your measure

Averages = SUM(YhdistettyTaulu[drivingindex]) / COUNTX(YhdistettyTaulu;[drivingindex])

have measure like
Sumx(values(YhdistettyTaulu[drivingindex]), if([Averages]>80,1,0))

Replace values(YhdistettyTaulu[drivingindex]) with the level(column) where you want to group and check >80

[Anonymous]

@amitchandak

So i'm trying to calculate a daily average driving index for each driver and increment it to the corresponding driving index on the X-axis.

I do not know if this helps but I have my count on the Y-axis and driving index values from 80 to 100 on the X-axis. If a driver’s daily average index is 81 for example I want it to increment the 81 value on the X-axis by 1 and if another driver’s daily average index is 83 increment the value 83 by 1.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format?