TopN Problems Same result

[Syndicate_Admin]

Hello, I am making a dashboard with open data on Bullying in Peru and I want to make a top 10 of the subtypes of violence, it should be noted that they are string data, and use this dax:

Top10 = CALCULATE([Subtypes],TOPN(10,ALL('DM Facts'[SUBTIPO_VIOLENCIA]),[Subtypes],DESC),VALUES('Type of SubViolence'[SUBTIPO_VIOLENCIA]))
[Subtypes] is COUNTROWS('DM Facts')
However, it gives me all the same results

Why would all the top 10 get the same results? Thanks a lot.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Syndicate_Admin]

I didn't know I had to share the download link.

[jdbuchanan71 · Accepted solution]

The TOPN is changing the fitler context to override the line, try it with a KEEPFILTERS.

Top10 =
CALCULATE (
    [Subtypes],
    KEEPFILTERS (
        TOPN ( 10, ALL ( 'DM Facts'[SUBTIPO_VIOLENCIA] ), [Subtypes], DESC )
    )
)

[Syndicate_Admin]

Indeed this is the solution, thank you very much.