Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

measure to table columns

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

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

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

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

Anonymous
Not applicable

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

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

Anonymous
Not applicable

Thank you
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.