How to not include columns in ranking

Hi Anonymous 

I build a table like yours to have a test, but in my pbix file your measure works well.

I think your SUM OF COUNT may be a measure/calculated column.

SUM OF COUNT = SUM(Tabelle1[1])

RANK = RANKX(ALL(Tabelle1[Product]),CALCULATE([SUM OF COUNT],ALLEXCEPT(Tabelle1,Tabelle1[Product],Tabelle1[Category])),,DESC)

Result:

Could you provide me with your data model, and tell me more details.

1. Is Rating column a calculated column or measure, and your calculate logic? 

2. Is Sum of count a measure and your calculate logic? I think the function you use may affect your result.

3. Please show me your data model in initial(with date column because you used it in your calculate).

4. You can try to add the all/allexcept/allselect function in filter table without in Expression, or try earlier function.

Or you can share your pbix file with me by your Onedrive for business.

Best Regards,

Rico Zhou

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