Count value and filter by other column

Gerald23 — Tue, 24 May 2022 12:43:01 GMT

Hi Everyone,

I have a table that looks like this:

Order Date	Order Number	Customer Number	Article Number	Qualtity Ordered	Sold Price	NP	SoldPrice-NP (This is a calculated Column)
1-1-2022	123	01	789	3	10.80	12.81	-2.01
2-2-2022	124	02	790	8	0.00	3.33	-3.33
13-2-2022	125	10	789	6	4.66	12.81	-8.15
14-2-2022	126	14	230	5	3.34	2.51	0.83
16-2-2022	130	25	486	1	2.40	1.06	1.34
18-2-2022	140	86	852	20	13.99	18.95	-4.96

Now i have created a measure to calculate the number of different items that are sold below the NP price that looks like this

Count #sold cheaper NP = CALCULATE(COUNT(Data[SoldPrice-NP]), Data[SoldPrice-NP] < 0)

But now I also want a measure that counts all articles that are sold below the NP price. So I need to count the values in the Quantity Ordered column but only when SoldPrice-NP is below 0. How could I achieve this?

Re: Count value and filter by other column

Gerald23 — Tue, 24 May 2022 12:58:15 GMT

That was easier then I expected xD

I used the code below to achieve this

Count all article below 0 = CALCULATE(SUM(Data[Quantity Ordered]), Data[SoldPrice-NP] < 0)

topic Re: Count value and filter by other column in DAX Commands and Tips

Count value and filter by other column

Re: Count value and filter by other column