cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

## Help with table with calculated colum

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

2 ACCEPTED SOLUTIONS
Super User

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors