Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX - Countif - more than 2 different type

Hey guys,

 

I'm totally new to the DAX language and would like to create a coloumn where I count how often one Business Unit Occurs.

 

Based on some googling I found some help, but unfortunately was not able to manage it:

 

Measure = CALCULATE(COUNT(ServiceDashboard[BU_Field]);
FILTER(ServiceDashboard
ServiceDashboard[BUId] = "REF"
ServiceDashboard[BUId] = "FIN"
ServiceDashboard[BUId] = "GL"
ServiceDashboard[BUId] = "PSS"

ServiceDashboard[BUId] = "SMT"))

 

 

Any help would be appreciated!

 

Many thanks!

 

Adam

 


Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    you can use the || in CALCULATE to tell calculate OR:

    CountRows of Color = COUNTROWS(DimProduct)

Count Rows of Black, Blue, Orange =
CALCULATE (
    [CountRows of Color],
    DimProduct[ColorName] = "Black"
        || DimProduct[ColorName] = "Blue"
        || DimProduct[ColorName] = "Orange"
)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    you can use the || in CALCULATE to tell calculate OR:

    CountRows of Color = COUNTROWS(DimProduct)

Count Rows of Black, Blue, Orange =
CALCULATE (
    [CountRows of Color],
    DimProduct[ColorName] = "Black"
        || DimProduct[ColorName] = "Blue"
        || DimProduct[ColorName] = "Orange"
)