Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

 

  • parry2k's avatar
    parry2k
    6 years ago

    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

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

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

      • parry2k's avatar
        parry2k
        Super 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.