Count dates with string value

[Taylormade]

Good Day,

I'm newbie at Power BI hopefully this is a simple question. I have a two tables: Table 1 has last completed dates and second column which has a string value it shows only if your "Current" within 1 yr of training or "Out of Date" outside yr window. Table 2 show name of courses. What I'm looking to get some help with is how to show on matrix report Name course with sum total of how many are current or out of date and drill down to show user and last completed date.

 

Thanks for advance help!

 

[Taylormade]

 

 

Thanks for the response. Attach is two sample report, which shows columns and tables related too.  Hopefully this what your looking for.

[Anonymous]

Hi, @Taylormade 

Sorry for not being able to fully understand your question. Can you give an example of where your calculations came from with sample data?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Taylormade]

What I'm looking for is to show training dates at the third level but keep sum total at top level(Org). Also show one attempt per course.

This is the query I was using but with no luck: 

Column = var _table=SUMMARIZE('User Table Date','User Table'[Training Current],'All Training Responses Main_Final'[User Training Date],"distinctcount",DISTINCTCOUNT('User table'[Training Current]))

return

SUMX(_table,[distinctcount])

Thank you again for taking the time to look over my questions. Hopefully it a little clear this time. 

[Anonymous]

Hi, @Taylormade 

You can refer to the following link to upload files with sensitive data please remove it in advance.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Taylormade]

Copy that sensitive data is remove. Here is my question in nutshell: How do I distinct count the number of dates by a user in a matrix report?

Ex. 

Organization	Username	Training Date
Group A	User A	9/1/2024
Group B	User B	9/2/2024
Group A	User C	9/3/2024
Group C	User D	9/1/2024
Group B	User E	9/2/2024
Group A	User F	9/5/2024

Drill down report 

+Org -> UserName -> User Training Date

[adudani]

hi @Taylormade ,

could you please provide sample input data in a usable format ( table, csv etc) masking sensitive information.