I got an error trying to sum up values using GENERATESERIES. I am not sure 100%, but I am pretty sure it works previously - 1-2 months ago.
CALCULATE([meassure], dim_table[field] = 5) -> works, works with 1 to 5 constants
SUMX(GENERATESERIES(1,5,1),[value]) -> works, got 15
SUMX(GENERATESERIES(1,5,1),
var val=[value]
return val
) -> works, got 15
SUMX(
GENERATESERIES(1,5,1),
var val=[value]
return CALCULATE([measure],dim_table[field]=val)
) -> doesn't work - Error Message: An unexpected exception occurred.
Feedback Type:
Frown (Error)
Timestamp:
2022-12-14T10:34:49.3674936Z
Local Time:
2022-12-14T10:34:49.3674936+00:00
Session ID:
cdae4095-61ae-48dd-ae2c-521767f3a45b
Release:
November 2022
Product Version:
2.111.590.0 (22.11) (x64)
Error Message:
An unexpected exception occurred.
Technical Details:
RootActivityId: 77792cec-33d4-4e21-ac60-4a1c43bcc4f2
Date (UTC): 12/14/2022 10:33:43 AM
OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 en-GB)
CLR Version:
4.8 or later [Release Number = 528372]
Peak Virtual Memory:
103 GB
Private Memory:
764 MB
Peak Working Set:
1.17 GB
IE Version:
11.789.19041.0
User ID:
42bebeb6-a895-4584-95ca-872fd4dd937f
Workbook Package Info:
1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.
Telemetry Enabled:
False
AS Live Connection:
True
Performance Trace Logs:
C:\Users\....\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_NlToDax
PBI_horizontalFusion
PBI_optimizeTabRibbon
PBI_relationshipEditPane
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
on:
URL is not filtering on field parameter