Calculations using the measures I created.

[Anonymous]

Hello,

I have data like the following,and created a measure called price.

*price =

DIVIDE([Sales],[Qty])

Then, to categorize this price
I created a DAX for the price range like this

*Pricerange = IF(AND([price]>=1, [tprice]<=10),"1-10",

IF(AND([price]>=11, [price]<=20),"11-20",

IF(AND([price]>=21, [price]<=30),"21-30",

・

・

・

IF([Productprice]>1000,"1000+", BLANK())

)))))))

I'd like to use this measure to determine the total price of a $10 product,  $20 product, and so on.

I've created such a DAX, but it does not work
*Amount_1-10 =

CALCULATE([sales],[pricerange]="1-10")

Any solution for this?

[lbendlin]

you probably need to expand the filter context to include the entire table, not just the current row.

By the way, your price range bucketing can be done a little simpler via SWITCH(TRUE(),...)

Pricerange =SWITCH(TRUE(),[Price]<=10),"1-10",[Price]<=20),"11-20",[Price]<=30),"21-30",...,"1000+")