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 LOOKUPID | FULLNAME | PROSPECTPLANNAME | PROSPECT PLAN DIMID | PROSPECT PLAN IS ACTIVE | Rating | primary manager | prospect manager | PROSPECTPLANSTATUS | PROSPECTPLANTYPE | PROSPECTPLANNAME | lifetime GIVING | Entity1Name | LAST GIFT FY | LAST GIFT DATE | DESIGNATIONPUBLICNAME | LAST GIFT AMT |
| 8000 | Dennis, Mrs. Tammi | B_NURS_Qualification | 1008 | 1 | K - $100,000 - $249,999 | Referrals & Transfers | No Constituent | Stewardship | Qualification | C_NURS_Qualification | $565.00 | Denniss, Mrs. Tammi | 2020 | 2/21/2020 | Nursing Scholarship Fund | $25.00 |
thanks,
Theresa Markham
