cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Count by Category in Matrix

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

1 ACCEPTED SOLUTION
Frequent Visitor

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

3 REPLIES 3
Frequent Visitor

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

Community Support

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.

Frequent Visitor

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.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors