Average of Two Columns on a Matrix

DAX DAX Calculations
1

I have a matrix, Provider ID, score 1(from table1),score2 (from table2), by Month.
The two tables are linked by Provider. I can’t just add and divide by 2 because there are blanks in some of the scores. I tried every version of AverageX and just can’t get it. Thanks for any help.

image
image664×541 24.1 KB

2

Hi @suellenjackson

Without PBIX it’s difficult to advise properly but try something like

Avg Score =
Switch(
    TRUE(),
    ISBlank( [Score1] ),
    [Score2],
    ISBlank( [Score2] ),
    [Score2],
    DIVIDE( [Score1] + [Score2], 2, Blank() )

Hope this helps

Pete

3

Hello @suellenjackson, just following up if the response above help you solve your inquiry?

If not, kindly provide the PBIX file @BINavPete requested so other users can help you further.

4

Hello @suellenjackson , it’s been a while since we got a response from you. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.