Forum Discussion

PaulMac's avatar
PaulMac
Helper IV
7 years ago

Having Issues With a Simple Calculation

Hello all   I am trying to replicate an excel formula in Power BI but I can't seem to do it.   I am trying to calculate the Total Calls per 1000 files uploaded.   In Excel column B contains Num...
Need Help
_donev's avatar
_donev
Regular Visitor
7 years ago

I assume your data looks like the picture below: 

 

In that case, if you try to create a New Column, your formula will work properly (as in the image above), as long as you are not using CALCULATE. 

  • PaulMac's avatar
    PaulMac
    Helper IV
    7 years ago

    Hi _donev

     

    No, my data looks like the picture below:

     

     

    Any thoughts?

     

    Kind regards

    Paul

     

    • _donev's avatar
      _donev
      Regular Visitor
      7 years ago
      PaulMac,
      Can you share a snap of your model? Are the 'All_Phones'[Offered] and 'Files uploaded'[API] measures? Are you creating a new measure or column?
      • PaulMac's avatar
        PaulMac
        Helper IV
        7 years ago

        I am still a novice with Power BI so may have to bare with me but I beleive I am creating a new measure that I wish to use in a matrix table on my report.

         

        My [Offered] column comes from the 'All Phones' table

        My [API] column comes from the 'Files Uploaded' table

         

        I have seen other users make new measures from columns from different tables that work but it feels like I am falling at the first hurdle.

         

        :smileyindifferent:

         

        Hope that provides some clarity.

         

        Kind regards

        Paul

         

         

    • BobBI's avatar
      BobBI
      Resolver III
      7 years ago

      try  DIVIDE function instead of calculate.

       

      Calls per 1000 = Divide([offered],[uploaded])*1000

       

      Offered and Uploaded are the 2 measure and Calls per 1000 should also be a measure.

      Thanks,

      SS