Measure if qty between interval and other column criteria true

[KasperJ90]

Hi

I have to create 3 measures based on intervals from the "Difference in days" column and if the column "Our Mistake" equals "No".

Measure1: sum Qty if "Difference in days" => 0 and <8 and "Our Mistake?" = "No"

Measure2:sum Qty if "Difference in days" =>8 and <21 and "Our Mistake?" = "No"

Measure3:sum Qty if "Difference in days" => 21 and <200 and "Our Mistake?" = "No"

Qty	Difference in days	Our Mistake?
300	5	Yes
1500	40	No

Can you help me do the correct formulas for creating the measueres in PowerBi?

Thanks

[Fowmy]

@KasperJ90

Add the following three measures

Measure1 = 
SUMX(
    FILTER(Table6, Table6[Difference in days] >= 0 &&   Table6[Difference in days] < 8 && Table6[Our Mistake?] = "No"),
    Table6[Qty] 
)

Measure2 = 

SUMX(
    FILTER(Table6, Table6[Difference in days] >= 8 &&   Table6[Difference in days] < 21 && Table6[Our Mistake?] = "No"),
    Table6[Qty] 
)

Measure3 = 

SUMX(
    FILTER(Table6, Table6[Difference in days] >= 21 &&   Table6[Difference in days] < 200 && Table6[Our Mistake?] = "No"),
    Table6[Qty] 
)

________________________

If my answer was helpful, consider Accepting it as the solution to help other members find it

Click the Thumbs-Up icon if you like this answer 🙂

Youtube Linkedin