I have this formula in power bi (DAX), is there a way to add it to qliksense?
Ped.Can2 =
CALCULATE([Distinct.Count],
GROUPBY(Sales,Sales[Client.ID]),
ALL(Products[Products]),
USERELATIONSHIP(Products[Products],'Base.Products'[Base Product]),
FILTER('Base.Products',SELECTEDVALUE('Base.Products'[Base Products])<>SELECTEDVALUE(Products[Products])))