Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
where
measure below is a simple SUM of prizes
and I need CALCULATE to give answer about a prize (Sprzedaż Suma) for a specific order number.
ID Pierwszego zlecenia =
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
Solved! Go to Solution.
Try
Pierwsze zlecenie =
VAR OrderID = [ID Pierwszego zlecenia]
RETURN
CALCULATE (
[Sprzedaż Suma],
FILTER ( Emisje, Emisje[ID zlecenia na reklamę] = OrderID )
)
Thank You! It works as it should 🙂
Best Regards
Andrew
Try
Pierwsze zlecenie =
VAR OrderID = [ID Pierwszego zlecenia]
RETURN
CALCULATE (
[Sprzedaż Suma],
FILTER ( Emisje, Emisje[ID zlecenia na reklamę] = OrderID )
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |