Forum Discussion
TopN Dynamic Filter in Matrix
v-alq-msft thanks, but I get the same result as before. It does not sum up the TopN items by brand, but rather sums ALL items by brand for the specific date. See below screen shot
The way your TopN measure works is different from what I need (you are showing TopN overall, where I need TopN Items by Brand). Other than that I followed your steps exactyl
Hi,
I cannot spot any mistake in the table there. I see the Top 4 items per brand and the total (112,164.73) seems to be the summation of only those 4 items. What is the problem?
Ashish_Mathuryou are correct, the matrix is working perfectly. The issue comes with the trending line graph. That is by brand (items are not a dimension there). But I want the values in the line graph to reflect only the sum of the TopN items associated with the brands. So I would expect all data points for the top brand in the line chart to total the 112,164.73, but they do not.
Ashish_Mathur It branched off into another question from the original Matrix issue which I then posted the issue here:
https://community.powerbi.com/t5/Desktop/TopN-Only-SUM-TopN-Items-for-Category-Total/m-p/1018556