cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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!:
Power BI Cookbook Third Edition (Color)

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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.