Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to perform set analysis to count something by having two fields equal each other. These two field are from different data tables - does that work?
The fields [Leads.LeadCode] and [Leaflet Design] are in different tables but a linked together by a common field.
count({1<[Leads.LeadType]={'Retail'}, [Leads.LeadCode]=[Leaflet Design], [Fixed_Dates.Date.autoCalendar.WeeksAgo]={"<=$(=$(vLastWeek)+12)>$(=$(vLastWeek)-1)"}, [Leaflet Design]={'RM155','HD211','LD106','LD215'}> distinct [Leads.LeadID]&[Leads.First]&[Leads.Last])
any help?
OK thanks, my concern was the the if statement was then not within the count function and i wanted to have a function that ignores filters. Can you do this with an if statement?
Yes that worked - Thanks. I actually had this solution previously but the aim was for the calculation to ignore all selections. At the moment, when i select a filter the chart updates (I would like it not to change).
Yes even when I use 1.. weird
You should be able to ignore selections even with an if statement
If(Only({1} [Leads.LeadCode]) = Only({1} [Leaflet Design]),
But if it is inside your Count function, you might not need it.... If you can share the exact expression which worked without any selection, we might be able to help you point out any changes that you might need in it to make it work with selections (everything ignored)