How to filter out unwanted value before using it in sum

[ZygisJank]

So i have this matrix and i would like to remove "NEZINOMA" , but if i remove it while transforming data then my other charts show lower values, and if i uncheck it in filter then my # skips its place and i get 1,2,3,4,5,7... 
I guess i would have to filter it some where in my measures.

[ZygisJank]

this is how i calculate #rank

# =

 IF( ISINSCOPE(Duom[pil_vls_pav]),

    RANKX(ALL(Duom[pil_vls_pav]),[Asmenys] + DIVIDE([alphabetical rank],100),,DESC)

 )


And this is the sum

Asmenys = SUM(Duom[asm_skaicius])

[Anonymous · Accepted solution]

Hi @ZygisJank ,

Try replacing ALLSELECTED with ALL. The ALLSELECTED function removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters. This means that if you don't check "NEZINOMA" in the filter, your filter will also remove "NEZINOMA".

# =
 IF( ISINSCOPE(Duom[pil_vls_pav]),
    RANKX(ALLSELECTED(Duom[pil_vls_pav]),[Asmenys] + DIVIDE([alphabetical rank],100),,DESC)

 )

Best Regards,

Stephen Tao

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