measure to table columns

[Anonymous]

Hello,
2 issues please:
1-
I have written the DAX below which returns three coumns with one of them being count.
I would like these columns to be shown in a table visual.
But when I write the visual inside the editor of powr bi it errors saying there is multiple columns

example data may not be accurate
vw table
--------
pKey pValue BandID
rew 34.66 2
uyt 95.44 7
...

Bands
------
BandID low high
1 1 30
...
6 45 199
...

Measure =
SUMMARIZE(
vw,
vw[BandID],
Bands[BandSize],
"Count", COUNT(vw[PKey])
)

2-
I have a column chart visual which I would like it when you click on one of the bars then the table above is to be filtered.
How is this done please?

Thank you

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous · Accepted solution]

Measure =
SUMMARIZE(
vw,
Bands[BandSize],
"Count", COUNT(vw[PKey])
)

I think table vw has vw[BandID] hence multiple columns. 

[Anonymous]

Thank you

[lbendlin]

Either use CONCATENATEX to cram all three returned columns of your measure into a single field, or split your measure into three, each returning only one column.