I need to create pivot table from data model to be able to pull a distinct count of an item, but then I'm unable to create a calculated field using that pivot table. How can I have the best of both worlds? I don't need a data model, but I do need to do a distinct count then and use that in a calculated field.

thank you!