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 again everyone ,

 

Could you please help me regarding this issue ? Rather than using usual reply , I only need to have how to count the calculated column which is solved below(countif) by Anonymous .

Regards

 

Burak

 

Greg_Deckler 

 

Regards

 

Burak