Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
TFernandes_2022
Frequent Visitor

Count by Category in Matrix

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

TFernandes_2022_0-1667416005209.png

 

1 ACCEPTED SOLUTION
TFernandes_2022
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")

TFernandes_2022_1-1667788688468.png

 

View solution in original post

3 REPLIES 3
TFernandes_2022
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")

TFernandes_2022_1-1667788688468.png

 

v-zhangti
Community Support
Community Support

Hi, @TFernandes_2022 

 

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

vzhangti_0-1667442191640.png

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

Result:

vzhangti_1-1667442228122.png

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.

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.

TFernandes_2022_0-1667445746661.png

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors