Matrix Table to Display Secondary Table Logic As Separate Columns To Values

[Krays23]

Hi Guys,

I have some grouping of values via secondary table logic I have used and I am trying to place this into a matrix table that contains values from other DAX calculations.

My issue is when I place my secondary table logic into that matrix table it puts it in as columns and aggregates the DAX I already have in that table which I don’t want to do. I want to maintain the layout of (Table 1) whilst adding (Table 2) to the end of the existing (Table 1)

I have attached a screenshot of the report I’m trying to reproduce for our procurement team. I want my matrix (Table 1) to replicate that.

This is how it looks now in PBIX file as 2 tables

I would like to combine (Table 2) into (Table 1) but maintain the columns of both tables

So final table would look like this

The issue is when i drop in my secondary table logic it re aggregates all columns in table 1 like this as the matrix table adds a layer onto the columns

Here is the excel report I’m trying to replicate in PBI

Stock Report EDNA.pbix (7.0 MB)

As always really appreciate your help and support

Dan

[Krays23]

Appreciate people are not obliged to reply to posts here, however i would just like to say that this forum used to be very active and is a key feature for me paying the subscription however over last 2 weeks I’ve posted 2 things and not had one response.

Bit disappointed in what used to be one of the driver for me.

just sharing an opinion hope that’s ok.

[EnterpriseDNA]

Hi @Krays23! We are sorry that you feel this way, however, some inquiries are out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!

[Rajesh]

Hi @Krays23

Welcome to the forum. Right now every one is busy with their year end plans.
Enterprise DNA is really amazing platform to learn Power BI.

Power BI works on Context based.

Table 1 - You are using individual measures.
Table 2 - You are grouping by Insurance group.

You can’t directly combine these two tables.

Create Individual measures for all possible values of Insurance group, like below and add those measures to Table 1.

[EnterpriseDNA]

Love how you provided solution on this thread @Rajesh. Appreciate your help on it.

We hope this helped you @Krays23

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

[EnterpriseDNA]

Hi @Krays23, due to inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, you can create a new thread.