Forum Discussion

Stoo48's avatar
Stoo48
Frequent Visitor
9 years ago
Solved

COUNTIFS Functionality in DAX

Trying to find a DAX equivilent to:   ACTIVITY =COUNTIFS([fault_code],[@[fault_code]],[equipment_id],[@[equipment_id]])   Have experimented with COUNT and CALCULATE but can't find a syntax that w...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Stoo48

     

    According to your description, you want to count rows which meet the criteria. Right?

     

    You can create a measure like below:

     

    COUNTIFS =
CALCULATE (
    COUNTROWS ( Table ),
    FILTER (
        Table,
        Table[fault_code] = fault_code1
            && Table[equipment_id] = equipment_id1
    )
)

    Regards,

     

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

Stoo48

 

According to your description, you want to count rows which meet the criteria. Right?

 

You can create a measure like below:

 

COUNTIFS =
CALCULATE (
    COUNTROWS ( Table ),
    FILTER (
        Table,
        Table[fault_code] = fault_code1
            && Table[equipment_id] = equipment_id1
    )
)

Regards,

 

vollmers's avatar
vollmers
Regular Visitor
8 years ago

shucks.. not quite for what i want..

 

I have 2 columns

 

mark - blue

mark - blue

suzy - red

suzy - blue

john - yellow

john - yellow

mary - blue

 

want a function in power bi that will give me the count of the # of times each combo exists.. to give this

 

 

mark - blue - 2

mark - blue - 2

suzy - red - 1

suzy - blue - 1

john - yellow - 2

john - yellow - 2

mary - blue - 1