cancel
Showing results for
Did you mean:
Frequent Visitor

## Sum of Measures Returning Incorrect Value

Hi all!

I've tried to find the solution for my problem on this forum but I couldnt found one.

I have 2 measures that works ok:

Line Items Late M = COUNTAX(FILTER(data,data[On Time to CAD]="N"),data[On Time to CAD])

and

Line Items On Time M = COUNTAX(FILTER(data,data[On Time to CAD]="Y"),data[On Time to CAD])

a third measure is a SUM between these 2 measures:

Total Line Qty = SUMX(data, [Line Items Late M]+data[Line Items On Time M])

the result of this measure is not correct.

2 REPLIES 2
Highlighted
Frequent Visitor

## Sum of Measures Returning Incorrect Value

Hi all!

I've tried to find the solution for my problem on this forum but I couldnt found one.

I have 2 measures that works ok:

Line Items Late M = COUNTAX(FILTER(data,data[On Time to CAD]="N"),data[On Time to CAD])

and

Line Items On Time M = COUNTAX(FILTER(data,data[On Time to CAD]="Y"),data[On Time to CAD])

a third measure is a SUM between these 2 measures:

Total Line Qty = SUMX(data, [Line Items Late M]+data[Line Items On Time M])

the result of this measure is not correct.

I have an example: First measure is 896 second one is 94 and the Sum of them is 1088.

Do you have an advice on this?

Thank you!

Community Support Team