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.

emutuc's avatar
emutuc
Frequent Visitor
2 years ago

Thanks.  when i create the expression

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

 

I get an error because the [count combined use] part is not found

 

Anonymous's avatar
Anonymous
Not applicable
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.