Get total value for different status

[NickzNickz]

In my dashboard, I use Visual Calendar by MAQ Software to show the status of planning, Advertisement, Selling and Closing as in the example below:

My problem is the status show the total of number for all status for the said date. 

Example #1  : 1 December 2023 (Friday). The actual # is 1 for Advertisement and 1 for Closing. (Total = 2)

Example #2  : 10 December 2023 (Sunday). The actual # is 1 for Planning, 1 for Advertisement, 2 for Selling and 1 for Closing. (Total = 5)

How can I achieve that .... 

Other Information :

In original table , I have multiple date column and other information. From there, duplicate the table and remove unnecesary column and remain only the date column. I use pivot table to consolidate multiple column date and become single date with different status.

Please let me know if need more information ...

Regards,

NickzNickz

[Deepak_]

Hi @NickzNickz ,

From what I can understand you want to count each status for a given date.
So I have tried this out in Power BI.
Data I am using : 

Solution: 

You can show the count of status to get the results you want.

Let me know if this is correct.

[NickzNickz]

@Deepak_ ,

The calendar visual I use requires the following information:

Based on the sample given, I need to have a column and I cannot use measure. As sample above, I created column name Total # Tender  but as we can see the total for each status appear the same .... 

Regards,

NickzNickz

[Deepak_]

@NickzNickz ,

Can you please share the column DAX you are using? That would be helpful

[NickzNickz]

Hi  @Deepak_ 

Total # Tender = CALCULATE(COUNT(f_event_list[Date]))

I believe we need to alter the DAX or the table ... 

Regards,

NickzNickz

@Deepak_