Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

using drill through with multiple criteria selection

hi there, 
this is my first post, so forgive me. here goes. 

I have a nice tool set up but my user would like to select multiple critera before using the drill through tool. I see that there is a way to write a DAX query, but most of the query suggestions I see are for time/date options. 
This report is for fundraising prospecting, so I need to select criteria like interest unit, with a prospect rating, or unit and the last gift amount. I've got some sample/dummy data, but I don't have a great way to share it right now
here's just the header and first row.

CONSTITUENT LOOKUPIDFULLNAMEPROSPECTPLANNAMEPROSPECT PLAN DIMIDPROSPECT PLAN IS ACTIVERatingprimary managerprospect managerPROSPECTPLANSTATUSPROSPECTPLANTYPEPROSPECTPLANNAMElifetime  GIVINGEntity1NameLAST GIFT FYLAST GIFT DATEDESIGNATIONPUBLICNAMELAST GIFT AMT
8000Dennis, Mrs. TammiB_NURS_Qualification10081K - $100,000 - $249,999Referrals & TransfersNo ConstituentStewardshipQualificationC_NURS_Qualification$565.00Denniss, Mrs. Tammi20202/21/2020 Nursing Scholarship Fund$25.00


thanks,
Theresa Markham

1 Reply