Forum Discussion

AnjaliChettiar's avatar
AnjaliChettiar
New Member
7 months ago
Solved

Need Help Averaging a Measure Derived from Two Other Measures

Hi All,
I am working on a Power BI report where I need to calculate the average of a derived measure.
This derived measure is calculated using two other base measures.
Here is the structure of my DAX logic:
  • Measure A -> base measure
  • Measure B -> base measure
  • Derived Measure -> calculated using Measure A and Measure B
  • Goal: Compute the average of the Derived Measure across a given dimension (ex-Dealer)

Kindly suggest solutions/approaches to resolve the query.

Need Help
Tips and Tricks
  • pankajnamekar25's avatar
    pankajnamekar25
    7 months ago

    Hello AnjaliChettiar 

     

    Try with AverageX

    Avg Derived Measure =
    AVERAGEX (
    VALUES ( Dealer[Dealer Name] ),
    [Derived Measure]
    )

     


    If my response helped you, please consider clicking
    Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn

     

  • FBergamaschi's avatar
    FBergamaschi
    7 months ago

    Hi AnjaliChettiar ,

    pankajnamekar25 offered you a solution with AVERAGEX, that works but it does not take into account blanks in the average calculation. if that is fine w/you, that is your solution. Otherwise if you need to take into account of blanks, consider this

     

    DIVIDE ( 
               SUMX ( VALUES ( Dealer[Dealer Name] ), [Derived Measure] ),
               COUNTROWS ( VALUES ( Dealer[Dealer Name] ) )
    )

     

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

5 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Icon for Super User rankSuper User
    7 months ago

    Hello AnjaliChettiar 

     

    Try with AverageX

    Avg Derived Measure =
    AVERAGEX (
    VALUES ( Dealer[Dealer Name] ),
    [Derived Measure]
    )

     


    If my response helped you, please consider clicking
    Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn

     

  • FBergamaschi's avatar
    FBergamaschi
    Icon for Super User rankSuper User
    7 months ago

    Hi AnjaliChettiar ,

    pankajnamekar25 offered you a solution with AVERAGEX, that works but it does not take into account blanks in the average calculation. if that is fine w/you, that is your solution. Otherwise if you need to take into account of blanks, consider this

     

    DIVIDE ( 
               SUMX ( VALUES ( Dealer[Dealer Name] ), [Derived Measure] ),
               COUNTROWS ( VALUES ( Dealer[Dealer Name] ) )
    )

     

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

  • cengizhanarslan's avatar
    cengizhanarslan
    Icon for Super User rankSuper User
    7 months ago

    Please try the logic below:

    Avg Derived (per Dealer) =
AVERAGEX (
    VALUES ( DimDealer[Dealer] ),
    [Derived]
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 months ago

    Hi AnjaliChettiar ,

     

    Thank you pankajnamekar25  for the response provided!

    Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

    Thank you.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 months ago

      Hi AnjaliChettiar ,

       

      I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

      Thank you.