topic Re: Count IF Function in DAX Commands and Tips

Count IF Function

Anonymous — Tue, 07 Dec 2021 11:24:29 GMT

Dear All,

Please help in correct the below tabular function. I am getting wrong answers in my tabulation.

ENQ Item Count = COUNTROWS(FILTER(ALL('Monthly report'),'Monthly report'[Item]=EARLIER('Monthly report'[Item]) || 'Monthly report'[Quotation number]=EARLIER('Monthly report'[Quotation number])))

Re: Count IF Function

Fowmy — Tue, 07 Dec 2021 11:41:53 GMT

Anonymous

Not sure where and how you execute this measure. Please try:

ENQItemCOUNT = VAR item = MAX ( 'Monthly report'[Item] ) VAR quote = MAX ( 'Monthly report'[Quotation number] ) RETURN CALCULATE ( COUNTROWS ( 'Monthly report' ), OR ( 'Monthly report'[Item] = item, 'Monthly report'[Quotation number] = quote ), REMOVEFILTERS ( 'Monthly report' ) )

Re: Count IF Function

Anonymous — Wed, 08 Dec 2021 04:04:43 GMT

Fowmy

Thanks for your kind reply and suggession.

I tried with you suggessions and results found "11" in all the rows in my tabulation.

Note, i have slightly modified your syntex due to error while running the same. Same was pasted in below for your review. Could you please check again and help me to resolve this.

ENQItemCOUNT =

VAR enqitem =

MAX ( 'Monthly report'[Item] )

VAR quote =

MAX ( 'Monthly report'[Quotation number] )

RETURN

CALCULATE (

COUNTROWS ( 'Monthly report' ),

OR ( 'Monthly report'[Item] = enqitem, 'Monthly report'[Quotation number] = quote ),

REMOVEFILTERS ( 'Monthly report' )

)

Re: Count IF Function

Anonymous — Wed, 08 Dec 2021 05:57:02 GMT

Fowmy

Through your guidance i got resolved my out come in tabulation. I have slightly modified your syntex as below. I am getting the desired results as expected with below syntex.

Thanks for your kind support.

ENQ Item COUNT =

VAR enqitem =

MAX ( 'Monthly report'[Item] )-1

VAR quote =

( 'Monthly report'[Quotation number] )

RETURN

CALCULATE (

COUNTROWS ( 'Monthly report' ),

OR ( 'Monthly report'[Item] = enqitem, 'Monthly report'[Quotation number] = quote ),

REMOVEFILTERS ( 'Monthly report' )

)

Re: Count IF Function

Fowmy — Wed, 08 Dec 2021 06:28:29 GMT

Anonymous

I believe you are creating a Calculated Column NOT a measure. If you are getting the expected results then, it should be fine.

Re: Count IF Function

Anonymous — Fri, 10 Dec 2021 02:45:43 GMT

Hi Anonymous ,

Could you please mark your post as Answered since you have gotten the desired result? It will help the others in the community find the solution easily if they face the similar problem with you. Thank you.

Best Regards