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 operati...
Need Help
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)