I’m having issues understanding the best way to use a DAX formula to count the unique # of values in a column once filtered… Here is an example table:
The Unique Donor ID counts the ‘consolidated donor household or unit’ of what it is I want to distinctly count as a single unit so that in the context of the filters I have on my report page. In this snapshot, the count of the Unique Donor ID should be 4. When I filter on my report page, any COUNT formulas I use don’t actually filter based on the row context so I’m not sure I’m understanding how to do this correctly.
I am trying to count “# of Donors” and use the Unique Donor ID to count how many donors there are in the context. Does that make sense?