Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following dax and I'm trying to sort (DESC) by "Transfers_X" (Total Transfer_X), but I'm not sure what it's doing as it's not being sorted by this, nor is it being sorted alphabetically by "Transfer Destination"
Top_10_Transfer_Destinations_LIst =
VAR Top10Destinations =
TOPN (
10,
SUMMARIZE (
DD_TRACE,
DD_TRACE[Transfer Destination],
"Total Transfer_X", SUMX (
FILTER (
RELATEDTABLE('TRANFERS_TRENDS'),
NOT(ISBLANK('TRANFERS_TRENDS'[Transfers_X]))
),
'TRANFERS_TRENDS'[Transfers_X]
)
),
[Total Transfer_X], DESC
)
RETURN
CONCATENATEX ( Top10Destinations, DD_TRACE[Transfer Destination] & ": " & [Total Transfer_X], UNICHAR(10))
Solved! Go to Solution.
Hi,
Does this work?
Top_10_Transfer_Destinations_LIst =
VAR Top10Destinations =
TOPN (
10,
SUMMARIZE (
DD_TRACE,
DD_TRACE[Transfer Destination],
"Total Transfer_X", SUMX (
FILTER (
RELATEDTABLE('TRANFERS_TRENDS'),
NOT(ISBLANK('TRANFERS_TRENDS'[Transfers_X]))
),
'TRANFERS_TRENDS'[Transfers_X]
)
),
[Total Transfer_X], DESC
)
RETURN
CONCATENATEX ( Top10Destinations, DD_TRACE[Transfer Destination] & ": " & [Total Transfer_X], UNICHAR(10),[Total Transfer_X])
Added the measure after the UNICHAR() function.
Hi,
Does this work?
Top_10_Transfer_Destinations_LIst =
VAR Top10Destinations =
TOPN (
10,
SUMMARIZE (
DD_TRACE,
DD_TRACE[Transfer Destination],
"Total Transfer_X", SUMX (
FILTER (
RELATEDTABLE('TRANFERS_TRENDS'),
NOT(ISBLANK('TRANFERS_TRENDS'[Transfers_X]))
),
'TRANFERS_TRENDS'[Transfers_X]
)
),
[Total Transfer_X], DESC
)
RETURN
CONCATENATEX ( Top10Destinations, DD_TRACE[Transfer Destination] & ": " & [Total Transfer_X], UNICHAR(10),[Total Transfer_X])
Added the measure after the UNICHAR() function.
Yes it did, thank you so much. Such a simple change. Very much appreciated.
You are welcome.
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |