Forum Discussion

EndriuBlack's avatar
EndriuBlack
Frequent Visitor
3 years ago
Solved

Measure doesn't show what it should

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

 

Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Try

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

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    Try

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