Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Matrix %RT% (few questions)

    My matrix is as below. I use the measure "Count = Count(Table[Delivery Status)" there twice. FIRST as a normal number  SECOND as a percentage of row total Its working like intended. However...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

In the latest release for matrix, if you right-click on the measure in visualization Tab, there is option % of row total, Are you looking for that?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, 

    My data looks similar to this:

    Store BannerPlanned Delivery DateActual Delivery DateDelivery Status
    Store 112/02/202012/02/2020On Time
    Store 213/02/2020 Pending
    Store 113/02/202015/02/2020Late
    Store 214/02/202014/02/2020On Time
    Store 113/02/202012/02/2020Early
    Store 114/02/202014/02/2020On Time
    Store 213/02/202014/02/2020Late
    Store 212/02/202012/02/2020On Time
    Store 211/02/202011/02/2020On Time
    Store 210/02/2020 Pending
    Store 29/02/202010/02/2020Late

     

    My manager has requested the out put (matrix visual) to be something like this:

    BannerEarlyOn TimePendingLateTotal
    Store 11 (25%)2 (50%)0 (0%)1 (25%)4 (100%)
    Store 20 (0%)3 (42%)2 (28%)2 (28%)7 (100%)

     

    I have it looking like so:

     

    That is close to what my manager is wanting and if i hide the headings and make my own title i get really close to the end result:

     

    Now I have another problem. I cannot show 0% for rows that have blank which I have use if statement to place 0 there already.

    Would you know a work around for this? I also do not know how to make brackets around my precentages

    • Icey's avatar
      Icey
      Community Support
      6 years ago

      Hi Anonymous ,

       

      The measure doesn't work because that there is no complete data for Delivery Status. 

       

      Try this:

       

      1. Please create a calculated table with Values to get the Delivery Status.

      Status = VALUES('Table'[Delivery Status])

       

      2. Create the relationship between the two tables.

       

      3. Create the matrix like below.

      Count = COUNT('Table'[Delivery Status])+0

      Then the measure could work.

       

       

       

      Best Regards,

      Icey

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thank you for your detail reply. 

         

        I think this method would work, however I think it is because for stores that dont exist for some at certain location, it can not show 0% because there was is nothing to calculate.  If I remove my page filter for location it works fine as all stores have status values.  

        This might need me to work with ISFILTER function.. I will have another play around.

         

        Cheers,

        Haley