Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Measure help

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.
 

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        amitchandak
        Super User
        5 years ago

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