Forum Discussion

bassmaninaus_PB's avatar
bassmaninaus_PB
Frequent Visitor
5 years ago
Solved

DAX Weighted Average using Divide without calculating zeros

Hi, I'm using the following DAX to calculate the weighted average of two columns. I have a large matrix table and using the below formula on several columns and just changing the values range each ti...
  • amitchandak's avatar
    amitchandak
    5 years ago

    bassmaninaus_PB , simply try like this

     


    Divide (
    SUMX( OpsLeaders, [6 Onshore Queued Volumes] * [18 Onshore Temps] ),
    SUMX( OpsLeaders, [6 Onshore Queued Volumes] ),0)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

bassmaninaus_PB , simply try like this

 


Divide (
SUMX( OpsLeaders, [6 Onshore Queued Volumes] * [18 Onshore Temps] ),
SUMX( OpsLeaders, [6 Onshore Queued Volumes] ),0)