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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors