Counting rows with lower value

Hi  Anonymous 

thank you for your reply.

Because you have same VII ID, and property of column Sąnaudos is Sum, so it will categorize automatically according to VII ID in table visual. If you don’t need total row, you can change the property to Don’t summarize,

Result:

Or if you need total row, try this.

Create the 2  measure:

calculatesum = CALCULATE(SUM('Sąnaudų lentelė'[Sąnaudos]),ALLEXCEPT('Sąnaudų lentelė','Sąnaudų lentelė'[VII ID]))

No of lower values = RANKX(ALL('Sąnaudų lentelė'),[calculatesum],,,Dense)

FYI:https://docs.microsoft.com/en-us/dax/rankx-function-dax

Result:

Best Regards,

Community Support Team _ Tang

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