Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi again,
I've solved one problem today, but hit another - so my code:
Itemlist =
CONCATENATEX (
CALCULATETABLE (
VALUES ( Sheet1[Items] ),
ALLEXCEPT ( Sheet1, Sheet1[id])
),
[Items], ", " , [Items]
)
Produces a list of items, sorted nicely, etc - however, each list is starting with a ',':
e.g.
", apple, cheese, orange"
there are some null values in the items list, but replacing these with a blank doesn't fix the problem, should I be checking with ISBLANK or similar?
Thanks again!
Solved! Go to Solution.
Itemlist =
CONCATENATEX(
CALCULATETABLE(
VALUES( Sheet1[Items] ),
ALLEXCEPT( Sheet1, Sheet1[id] ),
NOT ISBLANK( Sheet1[Items] )
),
[Items],
", "
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Itemlist =
CONCATENATEX(
CALCULATETABLE(
VALUES( Sheet1[Items] ),
ALLEXCEPT( Sheet1, Sheet1[id] ),
NOT ISBLANK( Sheet1[Items] )
),
[Items],
", "
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Perfect - thank you
Before you start building the string, filter out the values you don't want.
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |