Forum Discussion
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 each sales rep level. For example in below , you see 5 number of unit sold in last row but I need to make a formula determines non-blanks cell in each row , for this example it should be 4 rather than 5. Lastly , I will re-calculate those results per each sales rep by using countif formula again.(ex.ismail kazan). Is there anyone who can help me ?
10 Replies
Anonymous Excel to DAX translation is here: Excel to DAX Translation - Microsoft Power BI Community
COUNTIF is
COUNTX(FILTER(...)...) or CALCULATE(COUNT(),FILTER(...))
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.
COUNTIFS in DAX for Power Pivot or Power BI?
Best Regards
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.
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 .
RegardsBurak
Regards
Burak
