topic Re: Count by Category in Matrix in DAX Commands and Tips

Count by Category in Matrix

TFernandes_2022 — Wed, 02 Nov 2022 19:10:04 GMT

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

Re: Count by Category in Matrix

v-zhangti — Thu, 03 Nov 2022 02:24:54 GMT

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.

Re: Count by Category in Matrix

TFernandes_2022 — Thu, 03 Nov 2022 03:23:20 GMT

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.

Re: Count by Category in Matrix

TFernandes_2022 — Mon, 07 Nov 2022 02:41:21 GMT

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")