Power BI Exchange

Hello,

See attached excel for your reference.

Not sure how this can be achieved in PBI table.

I've 2 Status columns and 2 Description columns. Against each status column which says "No", I should get the below Output:

For instance - when we select "No" from Status 1 column, we see there are 4 Descriptions in Description 1 column, so this 4 description should come get populated against Each Description headers

Similarly - from Status 2 column, when "No" is selected, we have 2 Descriptions against this. So the 2 description should get updated against that specific column i.e. Description 2 column.

In column no. 3, I've added the Description names of each Headers.
I've around 10 Status and Description columns. Please advise, if there's a way to achieve this.

Thanking you in advance.

------------------------------
Prem Guru
------------------------------

Hi Prem,

You can do a dax calculation creating a table from this main table and combine it with union function. You can add as many status & description as you wish.



------------------------------
Rd 3nidad
Senior Finance Analyst
------------------------------

Original Message:
Sent: Dec 09, 2022 06:25 AM
From: Prem Guru
Subject: Help on Table

Hello,

See attached excel for your reference.

Not sure how this can be achieved in PBI table.

I've 2 Status columns and 2 Description columns. Against each status column which says "No", I should get the below Output:

For instance - when we select "No" from Status 1 column, we see there are 4 Descriptions in Description 1 column, so this 4 description should come get populated against Each Description headers

Similarly - from Status 2 column, when "No" is selected, we have 2 Descriptions against this. So the 2 description should get updated against that specific column i.e. Description 2 column.

In column no. 3, I've added the Description names of each Headers.
I've around 10 Status and Description columns. Please advise, if there's a way to achieve this.

Thanking you in advance.

------------------------------
Prem Guru
------------------------------

@Rd 3nidad,

Thanks! this is working as expected.

But is there a way we add multiple relationship between the Conso table and my Table?

For e.g. - we added ModelName, Color, Status 1 columns to the Conso table. Same level of columns are in my actual Table. I was able to create only one relationship between ModelName (Conso Table) and ModelName (My Table)

How can we add 2 more relationship between Color and Status 1 columns?

------------------------------
Prem Guru
------------------------------

Original Message:
Sent: Dec 09, 2022 07:29 AM
From: Rd 3nidad
Subject: Help on Table

Hi Prem,

You can do a dax calculation creating a table from this main table and combine it with union function. You can add as many status & description as you wish.



------------------------------
Rd 3nidad
Senior Finance Analyst

Original Message:
Sent: Dec 09, 2022 06:25 AM
From: Prem Guru
Subject: Help on Table

Hello,

See attached excel for your reference.

Not sure how this can be achieved in PBI table.

I've 2 Status columns and 2 Description columns. Against each status column which says "No", I should get the below Output:

For instance - when we select "No" from Status 1 column, we see there are 4 Descriptions in Description 1 column, so this 4 description should come get populated against Each Description headers

Similarly - from Status 2 column, when "No" is selected, we have 2 Descriptions against this. So the 2 description should get updated against that specific column i.e. Description 2 column.

In column no. 3, I've added the Description names of each Headers.
I've around 10 Status and Description columns. Please advise, if there's a way to achieve this.

Thanking you in advance.

------------------------------
Prem Guru
------------------------------