Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Everyone,
I have project on the power bi report builder. I wanna to add paramaters . I can add 3 paramaters but if i add more than paramater is not working. My error code like that:
Query ( The name '<ccon>RSCustomDaxFilter</ccon>' could not be resolved. It is not a valid table, variable, or function name.
this is my dataset query folder:
DEFINE VAR vFromFLDimCalendarcalendardate1 = IF(PATHLENGTH(@FromFLDimCalendarcalendardate) = 1, IF(@FromFLDimCalendarcalendardate <> "", @FromFLDimCalendarcalendardate, BLANK()), IF(PATHITEM(@FromFLDimCalendarcalendardate, 2) <> "", PATHITEM(@FromFLDimCalendarcalendardate, 2), BLANK()))
VAR vFromFLDimCalendarcalendardate1ALL = PATHLENGTH(@FromFLDimCalendarcalendardate) > 1 && PATHITEM(@FromFLDimCalendarcalendardate, 1, 1) < 1
VAR vToFLDimCalendarcalendardate1 = IF(PATHLENGTH(@ToFLDimCalendarcalendardate) = 1, IF(@ToFLDimCalendarcalendardate <> "", @ToFLDimCalendarcalendardate, BLANK()), IF(PATHITEM(@ToFLDimCalendarcalendardate, 2) <> "", PATHITEM(@ToFLDimCalendarcalendardate, 2), BLANK()))
VAR vToFLDimCalendarcalendardate1ALL = PATHLENGTH(@ToFLDimCalendarcalendardate) > 1 && PATHITEM(@ToFLDimCalendarcalendardate, 1, 1) < 1
EVALUATE SUMMARIZECOLUMNS('FL_Dim_Calendar'[calendar_date], 'FL_Dim_ArticleCategoryGroup'[article_category_group_desc_eng], 'FL_Dim_ArticleBrand'[article_brand_desc_eng], 'salesHierarchy'[countryCode], 'salesHierarchy'[salesCenter], 'salesHierarchy'[asm], FILTER(VALUES('FL_Dim_Calendar'[calendar_date]), (vFromFLDimCalendarcalendardate1ALL || 'FL_Dim_Calendar'[calendar_date] >= DATEVALUE(vFromFLDimCalendarcalendardate1) + TIMEVALUE(vFromFLDimCalendarcalendardate1)) && (vToFLDimCalendarcalendardate1ALL || 'FL_Dim_Calendar'[calendar_date] <= DATEVALUE(vToFLDimCalendarcalendardate1) + TIMEVALUE(vToFLDimCalendarcalendardate1))),
RSCustomDaxFilter(@salesHierarchyasm,EqualToCondition,[salesHierarchy].[asm],String), RSCustomDaxFilter(@salesHierarchysegment,EqualToCondition,[salesHierarchy].[segment],String),
"Penetrasyon", [Penetrasyon], "Outlet Count", [Outlet Count])
I don't know why this function is not working. Anyone could you resolve this problems?
Hi @Kubrasenses_ ,
I think you should create a query parameter and set its value to that of the existing report parameter (in Dataset Properties > Parameters).
Also, you should avoid Query Designer (in my experience).
For completeness, the full set of steps I followed:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.