Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

MdxScript(Model) Calculation error in measure

Hi

 

I am receiving this error when I try to create a Table visual in PowerBI Desktop.

 

MdxScript(Model) (186, 59) Calculation error in measure...The result of a conversion or arithmetic operation is either too large or too small. - see below for detail of error.

 

The visual is a table with a dimension "client" and the measure expression is ( cos/sales ). It should be a simple visual. Not sure if it may be because of "cos" being calculated from two different facttables.. or perhaps a tweak is required?

I am using a Tabular Model in Visual Studio/Analysis Services and LiveConnection in Power BI Desktop.

Please help 🙂

 

Error Message:
MdxScript(Model) (186, 59) Calculation error in measure 'Measures - KPIs'[Loss Ratio - Gross - Cumulative]: The result of a conversion or arithmetic operation is either too large or too small.

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , is kind of divide by zero error, cos/sales 

    Please make sure you have handled sales =0

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      Hi amitchandak Amit Thank you for your response. The table contains two columns. Year (DIM_Calendar) and Ratio. Ratio is calculated as "Cost" / "Sales" using the DIVIDE function. Cost expression is sum(DIM_Cost[Amount) and Sales expression is sum(DIM_Sales[Amount]. The table works when I use the Year dimension, but not when I use Client party DIM_Parties(Client).
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi amitchandak 

        Thank you for your response.

        The table contains two columns. Year (DIM_Calendar) and Ratio.
        Ratio is calculated as "Cost" / "Sales" using the DIVIDE function.
        Cost expression is sum(DIM_Cost[Amount) and Sales expression is sum(DIM_Sales[Amount].

        The table works when I use the Year dimension, but not when I use Client party DIM_Parties(Client).

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak 

       

      Please can you assist with how to handle sales = 0?

       

      this is what I have to address the issue you mentioned:

      **Loss Ratio - Gross - Cumulative:=**
      DIVIDE([Cumulative CLAIMS INCURRED ALL],[Cumulative GWP ALL],0)