Creating measure on dimension table column without bi direction filtering

Hi ArunTiruveedula 

Try this

Products Sold =
VAR keys_ =
    DISTINCT ( FACT_SALES[PRODUCT_KEY] )
RETURN
    CONCATENATEX (
        FILTER ( ALL ( DIM_PRODUCT ), DIM_PRODUCT[PRODUCT_KEY] IN keys_ ),
        DIM_PRODUCT[PRODUCT_NAME],
        ", "
    )

or this

Products Sold V2 = 
VAR keys_ = DISTINCT ( FACT_SALES[PRODUCT_KEY] )
RETURN
    CONCATENATEX (
        CALCULATETABLE(  DIM_PRODUCT, TREATAS(keys_, DIM_PRODUCT[PRODUCT_KEY] )),
        DIM_PRODUCT[PRODUCT_NAME],
        ", "
    )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers