Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Countif problem

Hi everyone ,   I have a table indicating number of sold units per product for each customer key. What I want to do is calculating countif formula like excel by counting row disregarding blanks per...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

You can create a calculated column as below:

Column =
COUNTROWS (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Item] = EARLIER ( 'Table'[Item] )
            && 'Table'[Subitem] = EARLIER ( 'Table'[Subitem] )
    )
)

In addition, you can refer the content in the following links to get it.

COUNTIF in Power BI

COUNTIFS in DAX for Power Pivot or Power BI?

Power BI COUNTIF

Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Unfortunately, you post could not help me. For best understanding , I am repeating my example's data.

 

Ismail Kazan is sales rep , numbers below it are his customers and total right side include number of products sold. So at the end of column I want to bring "4" for last row for my example by using countif formula. Because customer indicated "4022_337" got only 4 different product rather than considering total.