Forum Discussion

Rsanjuan's avatar
Rsanjuan
Icon for Advocate III rankAdvocate III
10 years ago
Solved

Moving Average as a Line Value in Combo Chart

Hello,

 

I am trying to create and display a dynamic average for a measure and input it in as a line value.

 

 

 

I already had created a new measure titled WinRate  --> WinRate = Divide([NumberofSales],[NumberofBids])

 

What would be the DAX expression to calculate the average for the new measure and input it into the "Line Value"?  Any help would be great.  Thanks!

 

 

Need Help

4 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Hi Rsanjuan

     

    Please try:

     

    Avg-WinRate = AverageX(All(Table1),[WinRate])

     

     

     

     

    • Rsanjuan's avatar
      Rsanjuan
      Icon for Advocate III rankAdvocate III
      10 years ago

      Vvelarde

       

       

      I tried it and it works!

       

       

      I believe it has the correct average, but is there any way possible I can remove the "1" that shows?  I can remove it by turning off the data label, but it will turn it off for the the bars as well, and want to keep that data label.

       

      • v-haibl-msft's avatar
        v-haibl-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        Rsanjuan

         

        Currently we cannot turn on/off the data label for specific series. You can vote this idea here.

         

        Best Regards,

        Herbert