Forum Discussion
Measure for Constant Line where numerator is a Measure
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 Thank you for the reply. It's not working. I notice that the [COUNT COMBINED USE] part isn't populating when i write the expression. Maybe because it's a measure?
see below for measure expression and error message
Like I said, all I could promise is that my solution wouldn't "throw the (same) error", because I don't have insight into your data model. And voila, it is now throwing a different error! Success! (sort of) 😂
If you re-create the problem with sample data in a .pbix file and upload it to google drive or catbox.moe or similar, then post the link, it is going to be much easier for me to help without having to ask a million questions back and forth 👍
What I can tell you is that measures can be referred to without the Table name in which they are found. Power BI enforces measures having unique names, so you can just refer to it as [COUNT COMBINED USE], you don't need the stuff before it. I'm not promising this will fix your problem, just something to note.
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
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.