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

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Have you solved this problem?

     

     

    Best Regards,

    Icey