Forum Discussion

Cre8's avatar
Cre8
Regular Visitor
3 years ago
Solved

HELP: Calculate average from functions, dynamic divisor

I have a question and urgently ask for your help!!! The following problem: I have four data columns which I can filter (e.g. by month). In Power BI I have calculated the average per column using th...
  • Cre8's avatar
    Cre8
    3 years ago

    Right answer from @AIB

    Measure =
VAR Count_ =
    INT ( [Measure1] <> BLANK () )
        + INT ( [Measure2] <> BLANK () )
        + INT ( [Measure3] <> BLANK () )
RETURN
    DIVIDE ( [Measure1] + [Measure2] + [Measure3], Count_ )
Cre8's avatar
Cre8
Regular Visitor
3 years ago

Right answer from @AIB

Measure =
VAR Count_ =
    INT ( [Measure1] <> BLANK () )
        + INT ( [Measure2] <> BLANK () )
        + INT ( [Measure3] <> BLANK () )
RETURN
    DIVIDE ( [Measure1] + [Measure2] + [Measure3], Count_ )