Need help with a simple DAX function, to count data occurence

[ephramz]

Hi, i'm new to PowerBI and i'm working on an automation process and i'm facing difficulties with PowerBI from converting over from excel. I was just wondering,
How do I create a new column(new DAX function), such that it give me the (count) by checking two column(s) of data row by row.

For example under the Op.No. Column and  Equipment column,

I want to count how many rows have this Op No. "9990" and Equipment column "243719208" value

For this case it should reflect as 2

Thanks!! Help is really appreciated!!

[VahidDM · Accepted solution]

Hi @ephramz 

Try to add a new column with this DAX code:

new column =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALLEXCEPT ( 'Table', 'Table'[Op.No.], 'Table'[Equipment] )
)

Output:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your Kudos  !!