Dynamic Columns Selection in SUMMARIZECOLUMNS based on user selection parameter

[Abh_90]

Hello All,

I need to create a dataset in Power Builder :.

I have two fact tables (Fact_Monthly et Fact_Weekly)

I have a parameter (@Period) with values (Monthly, Weekly)

I want to execute the SUMMERIZCOLUMNS based on user seletion

If user entered ="Monthly" =>get columns from Fact_Monthly
If user entered ="Weekly" =>get columns from Fact_Weekly
Here's my code

DEFINE

	VAR __DS0FilterTable1 = 
		TREATAS({@Period}, 'Calender'[Période])

EVALUATE

IF(@Period="Monthly",//i also tried IF(__DS0FilterTable1="Monthly",
	 SUMMARIZECOLUMNS(
		'Group'[Code Group],
		'Fact_Monthly'[FolderNumber],
		__DS0FilterTable1	
				)

	 ,SUMMARIZECOLUMNS(
		'Group'[Code Group],
		'Fact_Weekly'[FolderNumber],
		__DS0FilterTable1,
				)
)

But the __DS0FilterTable1 return a table not a unique value! So i can't compare it with a text in my IF statment !

And i get the error  : The expression refers to multiple columns... cannot be converted to a scalar value

Some help on how can i get the entered value ("Montly" or "Weekly") in the my parameter please !!

[Abh_90]

Thanks @some_bih !

I tried with query builder, it's always the same problem : getting a table result instead of unique text value !

the question is how can get the value (1) to compare it with the string (2) (monthly or weekly in english) ?

PS : the DAX of the measure SELECTEDITEM in my Power BI report is :

IF(HASONEVALUE('Calendar'[Période]),VALUES('Calendar'[Période]),BLANK())
//get selected period (Monthly or Weekly)

[some_bih]

Hi @Abh_90 "I have two fact tables", in DAX Studio, tables should be connected "properly" to leverage feature DAX builder (or any other functions/tool...). I do not details about your model.

[some_bih]

Hi @Abh_90 I recognize you use DAX Studio.

In DAX Studio, there is query builder to help with your case, check link

https://daxstudio.org/docs/features/query-builder/