show location when two products exist

[Anonymous]

I want an expression in a  chart that only flags Location_ID_Key if the location has two products, HEM and PSL.  Below does not work.  count({} DISTINCT Location_Id_Key)

[#2]

Hi

Please apply below formula with your field name in Expression and check if the location id is coming where location has 2 products.

IF(AGGR(COUNT(Location),Product)<2,0,AGGR(COUNT(Location),Product))

I guess it will help you.

Regards,

~Vinod

[MayilVahanan]

hi

Trylike this

count({<product={'PSL'}>*<product={'HEM'}>} DISTINCT Location_Id_Key) //this count the location id key where product contain both psl and hem..

hope it  helps