How to show negative value (infinity)

[Anonymous]

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

[parry2k]

@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.⚡

[Anonymous]

@parry2k COGS is Cost of Good Sold yes that also moved to SQL and relationship is also active.

[parry2k · Accepted solution]

@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.⚡

[Anonymous]

@parry2k you are right. the issue was in COGS Date Relationship was not working.

Thank you for your support.