All2Cheesy
Board Regular
- Joined
- Mar 4, 2015
- Messages
- 127
Hello all,
I have a matrix visualisation as seen below.
I'm attempting to replicate the value in the inbound% total section into Direction row in a new measure (Test Inbound%).
(Rows names: Branch, Service Type Group, Account Group, Direction)
I'm currently using the below formula, although, it doesn't seem to copy down over each row.
Test Inbound% = CALCULATE([Inbound %],ALLSELECTED('Table1'),VALUES('Table1'[Direction]))
I would need this to be the result (in red).
What would be the best way to achieve this? Thanks in advance.
I have a matrix visualisation as seen below.
I'm attempting to replicate the value in the inbound% total section into Direction row in a new measure (Test Inbound%).
(Rows names: Branch, Service Type Group, Account Group, Direction)
I'm currently using the below formula, although, it doesn't seem to copy down over each row.
Test Inbound% = CALCULATE([Inbound %],ALLSELECTED('Table1'),VALUES('Table1'[Direction]))
I would need this to be the result (in red).
What would be the best way to achieve this? Thanks in advance.
| Branch | Actual $ | Total Units | Inbound% | Test Inbound% |
| Adelaide | $443,304 | 58.859 | 59.35% | |
| Bulk | $295,615 | 8,296 | 56.32% | 56.32% |
| Revenue | 205,216 | 56.32% | ||
| Inbound | 56.32% | |||
| $205,216 | 56.32% | |||
| Handling | $38,701 | 4,473 | 58.84% | 58.84% |
| Inbound | $11,495 | 2,632 | 100% | 58.84% |
| Outbound | $13,259 | 1,841 | 58.84% | |
| $13,947 | 58.84% | |||
| PUD | $51,698 | 3,823 | 53.36% | 53.36% |
| Inbound | $0 | 2,040 | 100% | 53.36% |
| Outbound | 1,783 | 53.36% | ||
| $51,698 | 53.36% |
