Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 time.
18 Onshore Temps NHT =
IF( Divide (
SUMX( OpsLeaders, [6 Onshore Queued Volumes] * [18 Onshore Temps] ),
SUMX( OpsLeaders, [6 Onshore Queued Volumes] ))
= BLANK(), 0,
Divide (
SUMX( OpsLeaders, [6 Onshore Queued Volumes] * [18 Onshore Temps] ),
SUMX( OpsLeaders, [6 Onshore Queued Volumes] )))
Solved! Go to Solution.
@bassmaninaus_PB , simply try like this
Divide (
SUMX( OpsLeaders, [6 Onshore Queued Volumes] * [18 Onshore Temps] ),
SUMX( OpsLeaders, [6 Onshore Queued Volumes] ),0)
@bassmaninaus_PB , simply try like this
Divide (
SUMX( OpsLeaders, [6 Onshore Queued Volumes] * [18 Onshore Temps] ),
SUMX( OpsLeaders, [6 Onshore Queued Volumes] ),0)