Forum Discussion

istvan_gorgey's avatar
istvan_gorgey
Frequent Visitor
8 years ago

Insightly with Power BI Desktop

Dear Forum Members,

 

I'm suffering a bit with Insightly data connection.

I've added PowerBI data source using the Insightly connector and now I have the possibility to define measured values.

Otherwise, I can not create some multiplication.

 

I have a measure called 'VALUE' this contains the values for deals.

I have 'PROBABILITY' which one is not a measure but contains numbers

 

I would like to have something like this in coulombs:

 

DEAL NAME, DEAL VALUE, PROBABILITY, PROBABILITY*VALUE

 

The last one is not possible because it always wants me to add max, min or other calculations before probability.

Do you have any idea how to solve it?

 

Thanks in advance!

BR, István

10 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi istvan_gorgey,

     

    Based on my understanding, 'VALUE' is a measure, 'PROBABILITY' is a column, now you want to create a measure whose value is PROBABILITY*VALUE, right?

     

    If so, you have to use an aggregation function to wrap 'PROBABILITY'. As it is not supported to refer to a column that contains multiple values in a measure.

     

    You could try this, when you add the measure to table visual, you will get the correct product.

    New Measure=SUM('TableName'[PROBABILITY])*[VALUE]

     

    Regards,

    Yuliana Gu

    • istvan_gorgey's avatar
      istvan_gorgey
      Frequent Visitor
      8 years ago

      Hi Yuliana,

       

      Thanks for the quick feedback. Yeah I tried it but it will sum all of the probability values which should be a weight instead of sum function. 

       

      So somehow I should use a cycle or of statements to have all the value as a weight.

       

      If you have any idea please help me.

      Thanks in advance!

      BR, IStván

       

      • tonyinsightly's avatar
        tonyinsightly
        New Member
        8 years ago

        Hi istvan_gorgey,

         

        Insightly includes a weighted value field [OPPORTUNITY_VALUE_WEIGHTED], so the calculation is already done for you. Drop that into your report, and you should be all set.

         

        Cheers,

         

        Tony J. Roma
        Senior UX Technical Writer at Insightly