Problem in Top 3 Product Per Category

I Write a Code like @sam.mckay Video (Top 3 Sales People Per Region) But I Receive different result.
if you notice total of visual is sum of top 3 product not sum of all rows. anyone know reason of this result?

Yep you are calculating a TOP 3… and TOPN returns a table with just 3 rows so without any additional context that is the extent of your measure. However if that’s not the desired result you can add an IF ISINSCOPE Product Name, for example to return [SalesAmount] instead for the total row when there is no filter context coming from product.

1 Like