COUNTROWS returns wrong values

Anonymous — Mon, 22 May 2023 06:44:57 GMT

Below measure (PR_SPL_DATE_CHANGED) returns invalid result for me. When there is no records in the Products[PR_SPL_SALES_DATE] column, it returns the 1 as the output instead of 0.

Likewise it adds +1 with the count of available records. i.e. If 4 records available it returns 5 records.

I am not pretty much sure how it returns the +1 value with the COUNTROWS.

Could anyone assist me on this.

MIN_RUN_DATE = CALCULATE(MIN(Products[RUN_DATE]), LEFT(Products[RUN_DATE],4) = FORMAT(YEAR(TODAY()),BLANK()))

PR_SPL_DATE_CHANGED = IF((CALCULATE(COUNTROWS(VALUES(Products[PR_SPL_SALES_DATE])),

FILTER(Products, LEFT(Products[RUN_DATE],4) = LEFT([MIN_RUN_DATE],4)))) = 1,0,1)

Re: COUNTROWS returns wrong values

Anonymous — Wed, 24 May 2023 02:06:51 GMT

Hi @Anonymous ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

topic Re: COUNTROWS returns wrong values in Developer

COUNTROWS returns wrong values

Re: COUNTROWS returns wrong values