I need to count training classes from 1 table into another table using Power Pivot.

Question

question

TRiggs-1674 asked Dec 3, '21 TRiggs-1674 edited Dec 6, '21

I need to count training classes from 1 table into another table using Power Pivot.

I am trying to learn Power Pivots. I have three tables joined and am trying to pull in how many training classes each associate has taken into another table. My tables are called Associate List, Dept Number and Completed Training. I am in the Associate List trying to create a formula that counts each class each associate has taken in the Completed Training table. They are joined by Dept between the Associate List and Dept Numbers and by ID between the Associate List and Completed Training. I have a formula in Associate List stating - =DISTINCTCOUNT('Completed Training'[Training Title]) which counts the total distinct training classes for the entire workbook. I want it to count them for each associate. What would my formula be?

(I don't know what to put in the Tags field.)

office-excel-itpro

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft · Dec 06, 2021 at 08:44 AM

Hi @TRiggs-1674,
Could you please share us with some screenshots about your three tables.

Currently, I would suggest check whether CALCULATE function could be helpful.

0 ·

Answer 1 · 2021-12-06T12:00:29.933Z

TRiggs-1674 answered Dec 6, '21 TRiggs-1674 edited Dec 6, '21

image.png (29.4 KiB)

image.png (341.6 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question