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.
Hi All,
We have a requirement where we need to have the distinct values of a column in a measure , Can that be done in dax query or some other way.
you can use CONCATENATEX in DAX
Measure = CONCATENATEX(DISTINCT('Table'[Column]),'Table'[Column],",")
We just need distinct values of one column in measure, but measure dosent accepts column without any aggregate function or expression.
Thats the block.
CONCATENATEX is aggregating the values from the column into string - have you tried the code I've sent?
Yes, i tried. But due to some reason in september update of PowerBI i am not able to see CONCATENATEX function while creating a measure . Tried same with earlier version of power BI and its working there.
Thank You
Make sure it is a measure, not calculated column.
from what I see in your screenshot tha Data View is missing as well, so maybe there is something wrong with your instalation - I use the latest version of PowerBI and CONCATENATEX is there
for the View issue you can try going pressing Home>Edit Queries
https://community.powerbi.com/t5/Desktop/No-Data-View-Option/td-p/18003
it solved the issue for some, maybe it will fix it for you as well
Is dataview availabkle in direct query mode.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |