Forum Discussion

NickzNickz's avatar
NickzNickz
Helper IV
2 years ago

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: My problem is the status show the total of nu...
Need Help
NickzNickz's avatar
NickzNickz
Helper IV
2 years ago

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_'s avatar
Deepak_
Advocate I
2 years ago

NickzNickz ,

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

  • NickzNickz's avatar
    NickzNickz
    Helper IV
    2 years ago

    Hi  Deepak_ 

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

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

    Regards,

    NickzNickz

    Deepak_