DAX create calulated table with a specific column name and measures

[pravkan]

I have a sales table with below columns 

And I want to create a calculated table that will store bottom n retailer sales per product with the following columns 

1. Retailer Name
2. Product Sub Category Name 
3. Total Sales 

How can I achive this result?

[Anonymous · Accepted solution]

Hi @pravkan ,

I have built a data sample, please try to add two columns:

Rank Flag = RANKX('Table',[Total each Retailer],,ASC,Dense) *10+
RANKX(FILTER('Table',[Total each Retailer]=EARLIER('Table'[Total each Retailer])),[RETAILER_NAME],,ASC,Dense)

Final Rank = RANKX('Table',[Rank Flag],,ASC,Dense)

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Share data in format that can be pasted in an MS Excel file.  On that data, please also show the expected result very clearly.

[pravkan]

Hi @Ashish_Mathur ,

This what I want to achieve with Power BI

I have a table called V_BOTTOM_SALES and I want to create a measure that will rank my bottom n retailer with their product subcategory.

I don't know if this is possible in dax?

[Ashish_Mathur]

Please read my previous post.

[ryan_mayu]

@pravkan 

you can try this

Table 2 = 
VAR tbl=TOPN(3,'Table','Table'[sales],ASC)
return SELECTCOLUMNS(tbl,"retailer",'Table'[Retiler_name],"product",'Table'[product],"sales",'Table'[sales])

pls see the attachment below