Dax code in Power BI for getting specific column

Question

I need to get specific column which rows are depended on another column. Here is the raw example table,

I need a measure that gives the affiliate's names according to the number of different brands they are in.

For example;

x17 affiliate is included in only "B" brand, so it will be shown only 1 row.

1x2 affiliate is included in both "B" and "F" brands, so it will be shown 2 rows.

Sam Nseir · Accepted Answer · 2024-01-22 07:48:22Z

0

Measures don't return tables/columns.

If you are meaning or wanting to create a Calculated Table then you could try something similar to:

My New Table =
  SELECTCOLUMNS(
    SUMMARIZE('YourTable', [Affiliate], [Brand]),
    "Affiliate", [Affiliate]
  )

answered Jan 22, 2024 at 7:48

Sam Nseir

13.1k2 gold badges5 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ashok Anumula · Accepted Answer · 2024-01-22 08:21:19Z

0

Use this which returns a table of required column:

Table = SELECTCOLUMNS(DISTINCT('Table'), "Affiliate", 'Table'[Affiliate])

answered Jan 22, 2024 at 6:46

Ashok Anumula

1,5151 gold badge7 silver badges13 bronze badges