Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 without description yields 5 results. This is correct and the sales total is also correct. Adding the description changes the display and results seem to be unfiltered when the description is added. The grand total still shows for the top 5 but all part number results are displayed. The description is coming from invoiced sales and is not a unique field.
Solved! Go to Solution.
"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.
The invoiced sales material and description are both coming from the same table.
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |