Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to write a formula using set expressoins that says all selected items in DA and location, at the moment I get the P() on the right of the equals sign minus all values on the left of the equals sign.
How can I change this {[DA]<[Location] to be all selected items?
=count(distinct {[DA]<[Location]-=P([Group]::[Location])>} [Issue - ID])
Not sure what you are trying to do, but to get selected location, why can't you do this:
=Count(DISTINCT {DA} [Issue - ID])
Not really sure what you want to achieve, to assign all selected values in default set for field Location, try
=count(distinct {[DA]<[Location] = $::[Location])>} [Issue - ID])
or instead $ use Group set identifier:
=count(distinct {[DA]<[Location] =[Group]::[Location] >} [Issue - ID])