TOP N with Summary

[Anonymous]

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!!!

[v-yuta-msft]

@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.

[Anonymous]

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 total

[v-yuta-msft]

@Anonymous ,

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.