Forum Discussion

TFernandes_2022's avatar
TFernandes_2022
Frequent Visitor
3 years ago
Solved

Count by Category in Matrix

Is it possible to do cumulative count by category in Matrix (Red Lines)?  
Help with DAX
matrix
  • TFernandes_2022's avatar
    TFernandes_2022
    3 years ago

    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's avatar
TFernandes_2022
Frequent Visitor
3 years ago

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