Calculating Totals with filter but considering initial range

[Anonymous]

Hello,

I am seeking for help as i've been trying a couple days to solve this DAX calculation and I just can't figure it out.

I have a Table with orders, categories (SAL_TEMP) unit prices and number of units.

I have created a calculated column with ranges of prices.

Now, i want to calculate the aggregate of each order without considering the dimension"SAL_TEMP" and the calculated colum "BKT Price" but only from the "Contracts" appearing in first instance.

The result should be like this:

The Table1 down below shows how many orders have each category. I'm interested in the "Total" as i want to know for each "BKT Price"  how many units there are but only from the "Contracts" appearing on every row.

The Table2 shows how many units have each order.

If i do something like:

Calculated11 :=

CALCULATE(

SUM('ONLINE PowerBi'[Units]),

ALL('ONLINE PowerBi'[SAL_TEMP],'ONLINE PowerBi'[BKT Price])

)

The returned result is (as expected):

I can't attach the Pbix, but there's the table:

Order	SAL_TEMP	BKT Price	Price	Units	Family
90002842271	SALDO	2 - 2.99	2,43	1	185
90002842271	SALDO	3 - 3.99	3,24	1	173
90002842271	SALDO	3 - 3.99	3,24	1	177
90002842271	TEMPORADA	4 - 4.99	4,87	1	316
90002856331	SALDO	4 - 4.99	4,12	1	676
90002856331	TEMPORADA	4 - 4.99	4,95	1	942
90002842271	TEMPORADA	5 - 5.99	5,68	1	268
90002842271	SALDO	6 - 9.99	6,5	1	188
90002842271	TEMPORADA	6 - 9.99	8,12	1	133

If someone can give me a hand I would be incredibly grateful. 

Best regards,

[Anonymous · Accepted solution]

Solved! 💪 I was basically not being aware of the filter context. 

Just in case someone is in my pants, the solution is:

bis =

IF( ISINSCOPE('ONLINE PowerBi'[BKT Price]) ,

(CALCULATE(

(CALCULATE (

SUM ( 'ONLINE PowerBi'[Units]),

VALUES ( 'ONLINE PowerBi'[Order]),ALL('ONLINE PowerBi'[BKT Price],'ONLINE PowerBi'[SAL_TEMP])

)),

ALL('ONLINE PowerBi'[SAL_TEMP])

)),

BLANK()

)

And this returns: 

[Anonymous]

So far, i have accomplished this. Still not being correct though... @amitchandak thank you!

FINAL =

VAR var1=

CALCULATE (

SUM ( 'ONLINE PowerBi'[Units]),

VALUES ( 'ONLINE PowerBi'[Order]),ALL('ONLINE PowerBi'[BKT Price],'ONLINE PowerBi'[SAL_TEMP])

)

RETURN

IF( ISINSCOPE('ONLINE PowerBi'[BKT Price]) , var1, BLANK())

[amitchandak]

@Anonymous , I case you need value only at few place

then use isinscope

if( isinscope(Table[BKT Prive])  , [calculated 11], blank())