Finding number of occurrences of all distinct entries

[Idkpowerbi]

I have a dateseries data that would look like this. As you can see, multiple dates have multiple reasons and multiple agencies associated. Also the reasons and agencies have only certain number of distinct values. Now I need to find the number of occurrences of a reason and number of occurences of agencies and make visuals for them. 

[SamInogic · Accepted solution]

Hi @Idkpowerbi ,

It seems that you want to display count of occurrences based on Date, Reason or Agency, so you can add below changes in Power BI report.

You can achieve your Requirement in the Table visual by setting count of the Required columns,

Please check and let us know if this is the expected result or can let us know the required result.

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/