Forum Discussion

emutuc's avatar
emutuc
Frequent Visitor
2 years ago
Solved

Measure for Constant Line where numerator is a Measure

Hello, I need help with coming up with a measure that will be used as constant line to represent companywide average productivity versus an individual's productivity.     The numerator is a "measu...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,

    Thanks for the solution kpost  provided, and i want to offer some more information for user to refer to.

    hello emutuc , you can try the following meausre.

     

    Company Avg =
VAR a =
    SUMX ( ALLSELECTED ( 'Table1'[USERS] ), [COUNT COMBINED USE] )
VAR b =
    CALCULATE ( DISTINCTCOUNT ( 'Table1'[USERS] ), ALL ( 'Table1' ) )
RETURN
    DIVIDE ( a, b )

     

     

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kpost's avatar
kpost
Icon for Solution Sage rankSolution Sage
2 years ago

The part where you modify the filter context using ALL() should be an argument to CALCULATE, not an argument to AVERAGE.

So I cannot promise that this will do what you are intending since I can't see your data model, but I can promise you that this won't throw the (same) error:

Company Avg = CALCULATE(Average('Table1'[COUNT COMBINED USE]), ALL('Table1'[USERS]))

Note that a parenthesis has been added.