Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

CONFIDENCE.T Error Argument Wrong Type Too Small or Large

Rev E TOU by Loc CI =
VAR STDEnergy = [Revenue E TOU by Loc STDev]
VAR Alpha = [Sample CI Alpha]
VAR Size = DISTINCTCOUNT( 'AMI Data'[Location] )
Return CONFIDENCE.T( Alpha, STDEnergy, Size )  
 
This returns an error. However, when I request the measure to return the variables individually, they are all valid. When I hard-code the numbers, CONFIDENCE.T is returned.  Whenever I try the calculation with STDEnergy as an argument, I get the above-mentioned error.
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous ,
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Your offer of help is greatly appreciated. However, after working on a different part of the code and closing and re-opening the file, the measure now works. 

      This has happened to me before, and I find it to be one of the more infuriating things about Power BI. So please disregard.