DISTINCT COUNT of articles

[K-LED]

Hello,

For each month I'm calculating the DISTINCT COUNT of articles and I have this result below :

When I'm calculating the sum of the results for all months I have 2388. It's different from the sum displayed by the matrix visual 2280 :

The problem is some articles existed in different months...

How to calculte the sum for each month without counting the same articles for different months ?

Thanks in advance.

Regards.

[sturlaws]

Hi, @K-LED,

If I understand you correctly, you want to make sure an article is not counted in two different months. How to do this will depend on what your data look like.

Assuming your data has an orderID, your measure could look like this:

Measure =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            SUMMARIZE ( 'Table'; 'Table'[OrderID]; 'Table'[ArticleID] );
            "minDate"; CALCULATE ( MIN ( 'Table'[Date] ); ALL ( 'Table'[Month] ) )
        );
        [minDate] = CALCULATE ( MIN ( 'Table'[Date] ) )
    )
)

Cheers,
Sturla

[K-LED]

Hi,

Thanks @sturlaws for your response

Kind regards,