matrix visualization to display total and count metrics for cash receipts?

[MikeBresnan]

I'm probably just choosing the wrong metric or need to add some tables to bridge the data gap, but i am looking to create a matrix-like visualization that gives me both a count of cash receipt transactions, and their total in separate rows. The viz is pulling from a table of individual cash receipts.

I created 2 matrix visuals and overlapped them to give the impression of what i'm looking to do, but as the values change, they fall out of line with each other, and it starts to look wonky, as seen below.

My data is basically:

Company | Doc Date | Doc Number | Doc Amnt

[Anonymous]

Hi @MikeBresnan ,

Sorry for that the information you have provided is not making the problem clear to me🤔

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin

[samdthompson · Accepted solution]

Hello, simplest way is to

1. bring in your DocAmnt and your Doc Number into the values field.

2. Set the DocAmnt to 'sum' and set your Doc Number to 'countdistinct' (drop down arrow on field in values pane). Alternately you could write measures fro them.

3. under formatting, select values and set Show on rows to 'on'