Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Measure =
SUMMARIZE(
vw,
Bands[BandSize],
"Count", COUNT(vw[PKey])
)
I think table vw has vw[BandID] hence multiple columns.
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Measure =
SUMMARIZE(
vw,
Bands[BandSize],
"Count", COUNT(vw[PKey])
)
I think table vw has vw[BandID] hence multiple columns.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |