Top N and others in Matrix The Total only returns Top N total not include the others

[YILE]

Hi 

Please see belwo I use Top N to get the top 4 products and others. But in Marix it only calculate Top 4 total not include others. Could anyone help me to include others in Total?

[Anonymous · Accepted solution]

Hi  @YILE ,

You use the TopN() function and it will total based on the first N rows inside, Other is not in this N row and will not be totaled.

TOPN function (DAX) - DAX | Microsoft Learn

You can use IF+ HASONEVALUE to make a determination

HASONEVALUE function (DAX) - DAX | Microsoft Learn

Here are the steps you can follow：

1. Create measure.

Total =
var _table=
SUMMARIZE(
    'Table','Table'[Product],"Value",[TopN])
return
IF(
    HASONEVALUE('Table'[Product]),
    [TopN],SUMX(_table,[Value]))

2. Result:

Best Regards,

Liu Yang

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

[YILE]

Thank you so much!

[amitchandak]

@YILE , refer if this can help

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE