This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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 :)
Feedback Type:
Frown (Error)
Timestamp:
2020-10-16T10:28:55.4230656Z
Local Time:
2020-10-16T12:28:55.4230656+02:00
Session ID:
04be6843-7e7b-4cf9-8965-013119622f8e
Release:
August 2020
Product Version:
2. 84.981.0 (20.08) (x64)
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.
OS Version:
Microsoft Windows NT 10.0.18362.0 (x64 en-GB)
CLR Version:
4. 7 or later [Release Number = 528040]
Peak Virtual Memory:
40. 4 GB
Private Memory:
665 MB
Peak Working Set:
IE Version:
11. 1139.18362.0
User ID:
3b380113-c569-4c22-a766-e7ee19bf0676
Workbook Package Info:
1* - en-ZA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
AS Live Connection:
True
Performance Trace Logs:
C:\Users\niki\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_NewWebTableInference
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_ImportTextByExample
PBI_qnaLiveConnect
PBI_inlineExplore
PBI_v3ModelsPreview
PBI_dataSearchCuration
PBI_azureMapVisual
PBI_dataPointLassoSelect
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
125%
Supported Services:
Power BI
Formulas:
section Section1;
Hi @Anonymous ,
...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?
"MdxScript(Model) (186, 59) Calculation error in measure 'Measures - KPIs'[Loss Ratio - Gross - Cumulative]", the error message shows clearly, the result of a conversion or arithmetic operation is either too large or too small.
You need to ajust the conversion or arithmetic operation to make sure the result is suitable.
Could you please support sample data? And I will test on my own side.
More information: MdxScript(Model)(187,74).....Calulcation error in measure, MdxScript(Model) (27, 88) Calculation Error in measure
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.
Hi @m
Thank you for your response.
Unfortunately I cant share the data.
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)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
What expression are you using ? Could you share the code? It looks like datatype issue in this measure : 'Measures - KPIs'[Loss Ratio - Gross - Cumulative].
Loss Ratio - Gross - Cumulative:=
DIVIDE([Cumulative CLAIMS INCURRED ALL],[Cumulative GWP ALL],0)
Cumulative CLAIMS INCURRED ALL:=
VAR CumulativeTotal = CALCULATE([Gross Claims Incurred],
FILTER(ALL('SSAS V_DIM_AccountingPeriod - ReportingPeriod'),'SSAS V_DIM_AccountingPeriod - ReportingPeriod'[ReportingDateEnd]<=MAX('SSAS V_DIM_AccountingPeriod - ReportingPeriod'[ReportingDateEnd]))
)
RETURN
IF(ISBLANK([Gross Claims Incurred]),BLANK(),CumulativeTotal)
Cumulative GWP ALL:=
VAR CumulativeTotal = CALCULATE([Gross Written Premium],
FILTER(ALL('SSAS V_DIM_AccountingPeriod - ReportingPeriod'),'SSAS V_DIM_AccountingPeriod - ReportingPeriod'[ReportingDateEnd]<=MAX('SSAS V_DIM_AccountingPeriod - ReportingPeriod'[ReportingDateEnd]))
)
RETURN
IF(ISBLANK([Gross Written Premium]),BLANK(),CumulativeTotal)
Hi @Anonymous ,
Considering secure your sample data, I recommend you ask professional engineers for help, and they will deal with your problem separately and confidentially:
assistedsupportproducts
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.