Measure doesn't show what it should

[EndriuBlack]

Hello,

maybe someone could help with my problem.

I have a simple measure SUM with a FILTER but it doesn't aplly a filter as it should

here is my case:

My model is a simple two table model: Calendar and fact table

I don't understand why this calculation doesn't work:

Pierwsze zlecenie =

CALCULATE( [Sprzedaż Suma],

FILTER( Emisje, Emisje[ID zlecenia na reklamę] = [ID Pierwszego zlecenia] )

)

where 

measure below is a simple SUM of prizes

Sprzedaż Suma =

SUM( Emisje[Cena netto PLN] )

and I need CALCULATE to give answer about a prize (Sprzedaż Suma) for a specific order number.

FILTER( Emisje, Emisje[ID zlecenia na reklamę] = [ID Pierwszego zlecenia] )

The number of a specific ORDER is calculated in a measure: [ID Pierwszego zlecenia]) and Emisje[ID zlecenia na reklamę] is a column of order numbers.

[ID pierwszego zlecenia] is calculated like this:

ID Pierwszego zlecenia =

CALCULATE( _Miary[ID zlec],

FILTER( Kalendarz, 'Kalendarz'[Date] = _Miary[MIN Data Selected Rok])

)

and it gives the order number that I want

My table looks like this:

Order number is calculated well (ID pierwszego zlecenia), but the SUM of prizes for "Pierwsze zlecenie" shows me a sum of all revenue from a client in whole year (firs column is a name of client). I really don't know why FILTER function doesn'y apply only calculated order number "ID pierwszego zlecenia" to a measure.

Any idea what may be a problem? Cause I really don't know, this is very easy DAX this time. Order ID is calculated, and I just need a SUM of prizes of it...

I wolud be very gratefull if someone helps me 🙂

Best Regards

Andrew

[EndriuBlack]

Thank You! It works as it should 🙂

Best Regards

Andrew

[johnt75 · Accepted solution]

Try

Pierwsze zlecenie =
VAR OrderID = [ID Pierwszego zlecenia]
RETURN
    CALCULATE (
        [Sprzedaż Suma],
        FILTER ( Emisje, Emisje[ID zlecenia na reklamę] = OrderID )
    )