SUM on a SUMX measure

[MIkkelHyldig]

Hi, 

Currently I use a measure to display number of store with amount over 120.000 using this measure 

Measure 1 = SUMX(DISTINCT(Store[StoreKey]),IF('Measures.'[Stock Posting Amount DKK Dev.] > 120000,1,0)).

This returns 200 stores for the selected month in my filter. (in this case august 2022)

Additionally, I have a table with item categories where I wish to divide the total Stock Posting Amount DKK Dev. per category by 200 using a measure. Measure 2 = DIVIDE('Measures.'[Stock Posting Amount DKK Dev.] , [Measure 1])

However the tabel filters only return distinct store keys with [Stock Posting Amount DKK Dev.] > 120000 by item category.

Item category	Stock Posting Amount DKK Dev.	Measure 1	Desired result for Measure 1	Desired for Measure 2
A	10.000	180	200	500
B	50.000	120	200	250
C	2.000	0	200	10

How do I create a measure 2 that ignores the row context? Or do you guys have another solution? 

Thanks a lot! 

Mikkel

[MIkkelHyldig]

@v-chenwuz-msft 
Works perfectly with ALLSELECTED()

Thanks! 

[v-chenwuz-msft · Accepted solution]

Hi @MIkkelHyldig ,

ignores the row context,please use ALLSELECTED(). But i do not understand what you want. Please provide more detail about how to calcualte.

10000/200 = 500 ?

Best Regards

Community Support Team _ chenwu zhu