Help with table with calculated colum

[veng2002]

Hello everyone, 

I'm looking forward to get your insight and discover what I'm doing wrong here... I have a set of data that I'd like to add into a matrix to display in a very specific format. Let's say I have:

Server Name Open Inc Resolved Inc Priority
Server A	43	18	P1
Server A	24	24	P2
Server B	8	3	P1
Server A	21	12	P3
Server B	17	17	P4

And I'd like to present it as: 

Server Name     P1          P2      P3     P4
Server A	43 / 18	24 / 24	21 / 12	 
Server B	8 / 3	 	 	17 / 17

So I've created a new calculated colum wiith the following formula:

Join CR = CONCATENATE(COUNTA('Incidents'[Created]),CONCATENATE(" / ", COUNTA('Incidents'[Resolved])))

That formula gives me the format, but also the total number on each column, not individual values by column:

Server Name P1          P2    P3   P4
Server A	113 / 74	113 / 74	113 / 74	 
Server B	113 / 74	 	 	113 / 74

Can't seem to find a way to make it for each individual colum (priority)!

All your comments are welcome... 🙂 

[Greg_Deckler · Accepted solution]

Use a measure instead of a calculated column. Put Server Name in rows, Priority in columns and your measure in Values.

[v-qiuyu-msft · Accepted solution]

Hi @veng2002,

You can create a measure with below:

Join CR = CONCATENATE(MAX('Incidents'[Open Inc  ]),CONCATENATE(" / ", MAX('Incidents'[Resolved Inc])))

Then use a matrix visual to display data:

Best Regards,
Qiuyun Yu

[Greg_Deckler · Accepted solution]

Use a measure instead of a calculated column. Put Server Name in rows, Priority in columns and your measure in Values.