Count by Category in Matrix

[TFernandes_2022]

Is it possible to do cumulative count by category in Matrix (Red Lines)?

[TFernandes_2022 · Accepted solution]

Problem Solved 
Individually counting the categories

Ouro = CALCULATE(COUNT('Table'[Categoria]), 'Table'[Categoria] = "Ouro")

Prata = CALCULATE(COUNT('Table'[Categoria]), 'Table'[Categoria] = "Prata")

Broze = CALCULATE(COUNT('Table'[Categoria]), 'Table'[Categoria] = "Broze")

[v-zhangti]

Hi, @TFernandes_2022 

What is the format of your source data? I briefly simulated some data, hoping to match your situation.

Measure = CALCULATE(COUNT('Table'[Categoria]),ALLEXCEPT('Table','Table'[Categoria]))

Result:

Is this similar to what you expect?

Best Regards,

Community Support Team _Charlotte

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

[TFernandes_2022]

Hi @v-zhangti , thanks for your help. Your mock table is exactly the same as my source data, but the result I needed is the combination of the two tables.