MdxScript(Model) Calculation error in measure

[Anonymous]

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.

[amitchandak]

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

Please make sure you have handled sales =0

[Anonymous]

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)

[Anonymous]

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]

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).