Forum Discussion
How to show negative value (infinity)
Hi Everyone,
I was using excel as a database. I create a measure that shows the percentage in -/+ when I transfer the database in SQL its shows only positive value, negative value show infinity error. but I need a negative percentage.
Please help me out.
thanks
Avg of PI variance SIM-Accessory =
Var NullValue = "N/A"
Var _SIM = SUM(Combine_Data[PI Variances - SIM])
var _ACC = SUM(Combine_Data[PI Variances - Accessory])
Var _Combine = (_SIM + _ACC)
Var _Allowance = SUM(Combine_Data[1% Allowance Cost])
var _Percent = _Combine/[COGS]
Return
IF(ISBLANK(_Percent),NullValue,_Percent)SQL Version
Excel Version
Anonymous I know what COGS is but my question was, is it a measure? if yes what is the expression, are you getting the value in COGS tables, for debug purpose, visualize if you are getting cogs values and go from there.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
4 Replies
- parry2kSuper User
Anonymous what is COGS, can you make sure there is value in COGS when you are switching to SQL
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- AnonymousNot applicable
parry2k COGS is Cost of Good Sold yes that also moved to SQL and relationship is also active.
- parry2kSuper User
Anonymous I know what COGS is but my question was, is it a measure? if yes what is the expression, are you getting the value in COGS tables, for debug purpose, visualize if you are getting cogs values and go from there.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡