Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX calculation for weighted average

Hi All -    Hoping to find DAX help in calculating Weighted Average in power BI.  In excel, I had my calculation as : Calculation for "Bond 1 and Bond 2"   1- How do I write that weight av...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file whether it suits your requirement.

     

     

    Only Bond weight avg: =
DIVIDE (
    SUMX (
        FILTER ( Data, NOT ( Data[Category] IN { "String", "Stock" } ) ),
        Data[Balance] * Data[Rate]
    ),
    SUMX (
        FILTER ( Data, NOT ( Data[Category] IN { "String", "Stock" } ) ),
        Data[Balance]
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Please check the below picture and the attached pbix file whether it suits your requirement.

 

 

Only Bond weight avg: =
DIVIDE (
    SUMX (
        FILTER ( Data, NOT ( Data[Category] IN { "String", "Stock" } ) ),
        Data[Balance] * Data[Rate]
    ),
    SUMX (
        FILTER ( Data, NOT ( Data[Category] IN { "String", "Stock" } ) ),
        Data[Balance]
    )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi - Very much appreciated. Thank you so much