Forum Discussion
Dataset query error in report builder
Hi , I am using report builder to connect to a power BI dataset. when I use the following DAX query, then it throws an error. does anyone know how to fix it? EVALUATE
VAR a =
SUM...
Here's the corrected code:
EVALUATE
VAR a =
SUMMARIZECOLUMNS (
'table1'[id],
'table2'[cid],
RSCustomDaxFilter(@CDate,EqualToCondition,[CycleDate].[Date],DateTime),
"MTD Sub ANP", [MTD Sub ANP],
"Flag", 0,
"Order",FORMAT(VALUE(MAX('CHANNEL'[Order])), "#00.0")
)
VAR b =
SUMMARIZECOLUMNS (
'table1'[type_id],
'table2'[cid],
RSCustomDaxFilter(@CDate,EqualToCondition,[CycleDate].[Date],DateTime),
"MTD Sub ANP", [MTD Sub ANP],
"Flag", 0,
"Order",FORMAT(4.5 , "#00.0"),
FILTER(CHANNEL , CHANNEL[ID] in {5,6})
)
return
UNION(a,b)