Forum Discussion

m_wex's avatar
m_wex
Icon for Helper I rankHelper I
5 years ago
Solved

Adding fields is impacting results

Using the following Dax to create top sales by part number. The total sales by part number come out correctly but when a description is added the result is impacted. For example, selecting top 5 with...
  • m_wex's avatar
    m_wex
    5 years ago
    Solved the issue. Added another field to the rankx calculation for description. Once this was implemented the problem solved. 
     
    Total PN ales by Rank TEST =
    VAR
    RankingDimesion=Values(Sales[Material])
    Var
    RankingSelect = [Ranking Select PN]
    Return
    CALCULATE([Total Sales],
    Filter( RankingDimesion,
    RankX(all(Sales[Material], Sales[Description]) ,[Total Sales], ,desc )<= RankingSelect))
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

"The description is coming from invoiced sales and is not a unique field. "

 

The description needs to come from the same row of the table where you get the part number from.

m_wex's avatar
m_wex
Icon for Helper I rankHelper I
5 years ago

The invoiced sales material and description are both coming from the same table.