Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
NickzNickz
Helper IV
Helper IV

Get total value for different status

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:

NickzNickz_1-1708652107195.png

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.

NickzNickz_0-1708654095120.png

Please let me know if need more information ...

 

Regards,

NickzNickz

 




 

 

4 REPLIES 4
Deepak_
Helper I
Helper I

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 : 

Deepak__1-1708668190773.png

Solution: 

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

Deepak__2-1708668313197.png


Let me know if this is correct.




 

@Deepak_ ,

 

The calendar visual I use requires the following information:

 

NickzNickz_0-1708674620782.png

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

 

@NickzNickz ,

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

Hi  @Deepak_ 

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

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

Regards,

NickzNickz

@Deepak_

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.