Distinctcount shows duplicated lines but the total is correct

[RustyD]

hi, 

as in the subject.  I have a counter of PO numbers and I use DISTINCTCOUNT for that. It was working but recently we appended the PO table with other containing different attributes/columns. 

Now the #PO  shows the correct total  but displays empty (like duplicated rows) rows of that attitional table even if no column from that table is added to the report. 

without Distinct #PO count:

With #PO count  but without column from additional table,  counts empty line - not expected result. 

With #PO count but also with column from additional table (IR)  so this is correct behaviour:

How can I get rid of the empty line from the 2nd screenshot ? 

Thanks for any hints. 

[RustyD · Accepted solution]

hi again,

but actualy you gave an idea.

I have created an identifier column which rows come from PO table and which from others and then I used it as filter in the calculate formula:

#PO =
CALCULATE(
DISTINCTCOUNT('Purchase Orders'[PO number]),
'Purchase Orders'[Table_Identifier]="Purchase Order")

[RustyD]

hi @bhanu_gautam  thanks for reply. 

Unfortunatelly it is not working and giving same result as previous measure. 

Also I forgot to stress is out that all rows are now in 1 table (after append) . Also there might be more columns with empty rows so it would not be efficient to include all of them in formula. 

[bhanu_gautam]

@RustyD , You can try to create a measure to filter out the empty rows. For example, you can create a measure that counts the distinct PO numbers only if there is a corresponding value in the additional table

DistinctPOCount =
CALCULATE(
DISTINCTCOUNT('POTable'[PONumber]),
NOT(ISBLANK('AdditionalTable'[SomeColumn]))
)