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

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'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_