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 mode...
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 )
    )
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 )
    )