Forum Discussion

AnnieV's avatar
AnnieV
Frequent Visitor
1 year ago
Solved

MdxScript(Model)(17,3) calculation error

I'm working with a measure defined as:  GLOS = VAR Number = [GProduct] VAR ThisRoot = [IP_Count] RETURN Number ^ (1 / ThisRoot)   [GProduct] is the result of a PRODUCT(Numeric Colum...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Yes, Int64 is the limit. Embarrassingly Power BI does not support Int128.

     

    Have you tried the logarithm approach?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Cannot reproduce. Something else must be at play.

 

 

  • AnnieV's avatar
    AnnieV
    Frequent Visitor
    1 year ago

    So I made an Excel with 2 columns ID and VALUE, ID running from 1 to 10,000 and VALUE filled  by a random number using  =RANDBETWEEN(1,1000)/100

     

    Used that as the data source, making sure that VALUE was typed as a decimal. 
    Measure: 

    GLOSTest =
      VAR Number = PRODUCT('Sheet1'[VALUE])
      VAR ThisRoot = COUNT('Sheet1'[VALUE])
      RETURN
      Number ^ (1 / ThisRoot)
     
    And getting an error still, if I filter to ID values below something like 500 I get a return value, otherwise throws the same error: