Forum Discussion
Top 10 sorting
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))
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.
3 Replies
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.
You are welcome.