Forum Discussion

justinh's avatar
justinh
Advocate IV
2 years ago
Solved

Using SWITCH within KEEPFILTERS and IN?

Is it possible to switch out the list inside of a KEEPFILTERS IN argument? I can't seem to get it to work.  I want my end user to be able to make a parameter selection, and that selection changes...
Need Help
Tutorial Requests
  • justinh's avatar
    justinh
    2 years ago

    This version even keeps the "KeepFilters" in place:

     

    VAR _UserSelection= [Selected Conversion Type]
VAR _Table = 
	CALCULATETABLE(
		SUMMARIZE(
			b_Assortment_Bridge,
			b_Assortment_Bridge[Inventory_Key],
			b_Assortment_Bridge[Assortment StdCost Ratio],
			b_Assortment_Bridge[Assortment Flag]
		),
		KEEPFILTERS( 
			SWITCH(
				_UserSelection,
				"Both",
					b_Assortment_Bridge[Assortment Flag] IN {"", "A", "B"},
				"A Only",
					b_Assortment_Bridge[Assortment Flag] IN {"", "A"},
				"B Only",
					b_Assortment_Bridge[Assortment Flag] IN {"", "B"},
				"Off",
					b_Assortment_Bridge[Assortment Flag] IN {""}
			)
		)
	)
VAR _Measure = 
	SUMX(
		_Table,
		CALCULATE( [.Sales - Selling SKUs] ) * [Assortment StdCost Ratio]
	)

RETURN
	_Measure

     

justinh's avatar
justinh
Advocate IV
2 years ago

This was the cleanest I could make the code and have it still work as expected.

 

  • justinh's avatar
    justinh
    Advocate IV
    2 years ago

    This version even keeps the "KeepFilters" in place:

     

    VAR _UserSelection= [Selected Conversion Type]
VAR _Table = 
	CALCULATETABLE(
		SUMMARIZE(
			b_Assortment_Bridge,
			b_Assortment_Bridge[Inventory_Key],
			b_Assortment_Bridge[Assortment StdCost Ratio],
			b_Assortment_Bridge[Assortment Flag]
		),
		KEEPFILTERS( 
			SWITCH(
				_UserSelection,
				"Both",
					b_Assortment_Bridge[Assortment Flag] IN {"", "A", "B"},
				"A Only",
					b_Assortment_Bridge[Assortment Flag] IN {"", "A"},
				"B Only",
					b_Assortment_Bridge[Assortment Flag] IN {"", "B"},
				"Off",
					b_Assortment_Bridge[Assortment Flag] IN {""}
			)
		)
	)
VAR _Measure = 
	SUMX(
		_Table,
		CALCULATE( [.Sales - Selling SKUs] ) * [Assortment StdCost Ratio]
	)

RETURN
	_Measure