Forum Discussion
TOP N with Summary
TOP N with Summary of Customer column is giving right total but if we split by other attribute split is not giving right.
Example :
Need to show TOP 100 Customer by sales data (e:g: 100M is the total of top 100 customers) by region and year.
Sum of TOP 100 customer data, But while showing in matrix visual it will be region in row and year in colum ( adding of rows sum and column needs to give total sum of 100M)
Thanks in advance!!!
3 Replies
Anonymous ,
You can use DAX functon TOPN():
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])
https://docs.microsoft.com/en-us/dax/topn-function-dax
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yuta-msft
Yes am using TOPN function but not getting expected result.
SUMX(TOPN(100,SUMMARIZE(Table, Table[Customer],"TOTAL", SUM(Table[Sales])),[TOTAL],DESC),[TOTAL])Final total is right but when i split this data in matrin with region and year, split of data is not equal to Grand totalAnonymous ,
Could you share some sample data for further analysis?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
