TOPN N (DAX Formulas) Issues

Souzaeq — Fri, 27 Oct 2023 19:04:06 GMT

I want to have a column or a line with TOP N (lets say 3) products sold in a period, working along the data calendar hierarchy. Like, what were the top 3 products sold per year, quarter, month, day according pivot table data hierarchy.

Files and prints attached

Please refer to pivot table in tab Pivot Table (6) to check the measure I tried to use.

Problems Im facing:

1 I'v tried a bunch of top n tutorials and none of them work. Some use summarize, sumx, concatenatexâ€¦ Question: I cant just use straight ahead TOP N like a function to have a column or line in the pivot table the 3 most sold products? I have to use some function to initialize the TOP N?

2 I did the relationship between tblProducts and tblOrders but the tblProducts does not show on the fields to select into the pivot table. Why?

3 =sumx(TOPN(3, SUMMARIZE(tblOrders, Calendar'[Date],topn sales,sum(tblOrders[Qty])),[topn sales],DESC),[topn sales])

tried this formula, but function sum [sum(tblOrders[Qty])] only accepts a table column and not another measure (used [Qty] so it could work).

Id like to use the top 3 from Total Revenue X, how can I do that?

Summarizing everything, how can I have the Top 3 products sold by period?

Power Pivot Training - BEGIN - TS Fiscal Calendar.xlsb

Re: TOPN N (DAX Formulas) Issues

lbendlin — Sat, 28 Oct 2023 23:16:00 GMT

Please note that .XLSB is not a preferred format. Can you please provide the sample in .XLSX ?

topic Re: TOPN N (DAX Formulas) Issues in DAX Commands and Tips

TOPN N (DAX Formulas) Issues

Re: TOPN N (DAX Formulas) Issues