Visual filtered with a characteristic of the selected row

[BMltc]

Hi Community,

I have a simple question, and apologize if this has already been answered. I have a table data

Name	Sector	Value
A	Sector 1	1
B	Sector 2	5
C	Sector 1	4
D	Sector 3	7
E	Sector 1	8
F	Sector 2	4
G	Sector 1	5
H	Sector 2	3
I	Sector 2	4

I have a table visual like above and when I select a row (let's say A), I want another visual to show every row with the same sector (Sector 1 in my example) with their values

Name	Sector	Value
A	Sector 1	1
C	Sector 1	4
E	Sector 1	8
G	Sector 1	5

Can someone help me?

Many thanks

Boris

[Ashish_Mathur]

Hi,

Drag Sector to the row labels of the Tabel visual and filter it on Sector 1.

[v-yingjl · Accepted solution]

Hi @BMltc ,

You need to create a calculated table first:

test = 
SUMMARIZE(
    'Table',
    'Table'[Name],
    'Table'[Sector],
    'Table'[Value]
)

Then create a control measure and set its value as 1 in the table visual filter:

Control = 
var _t1 = SELECTEDVALUE('Table'[Sector])
var _t2 = SELECTEDVALUE(test[Sector])
return
IF(
    _t1 = _t2 ,1,0
)

Attached the sample file that hopes to help you: Visual filtered with a characteristic of the selected row.pbix

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[BMltc]

Maybe a follow up question if I may @v-yingjl , I would prefer to show the 'Test' table as a stacked column chart, ideally with the row selected in Table highlighted in the chart, do you think it is possible?

Many thanks again,

[v-yingjl]

Hi @BMltc ,

Write this simliar measure and put it in the value field:

Measure 2 = 
var _t1 = SELECTEDVALUE('Table'[Sector])
var _t2 = SELECTEDVALUE(test[Sector])
return
IF(
    _t1 = _t2 ,SUM(test[Value]),0
)

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[BMltc]

Perfect! thanks

[BMltc]

Perfect, thanks a lot, many thanks to all

[amitchandak]

@BMltc , Try like

measure =

var _tab = distinct(filter(all(Table), table[name] =selected(Table[name])),[Sector])
return
calculate(sum(table[Value]),filter(All(Table), Table[Sector] in _tab))

But better a new disconnected table for Name so that you can avoid all

measure =

var _tab = distinct(filter((Table), table[name] =selected(Name[name])),[Sector])
return
calculate(sum(table[Value]),filter((Table), Table[Sector] in _tab))

[BMltc]

Hi @amitchandak ,

Many thanks for your help. The Selected function does not seem to be supported in Dax, did you mean allselected or selectedValues?