Equivalent of HAVING in DAX

[Anonymous]

Hi,

I'm pretty sure this must be a trivial question for a seasoned DAX users.

I wan't to filter out all rows for which ItemValue equals zero. If ItemQty <> 0 but ItemValue = 0 such a row should still be filtered out.

In SQL this would by done by a HAVING clause. Not sure how to achieve the same in DAX.

SUMMARIZECOLUMNS(
		Transacts[Account],
		Transacts[Items],
		"ItemQty", SUM(Transacts[Quantity]),
		"ItemValue", SUM(Transacts[Amount]),
		"ItemAvgPrice", DIVIDE(SUM(Transacts[Amount]),ROUND(SUM(Transacts[Quantity]),4))
	)

[barritown]

Hi @Anonymous,

I'd use such a construction - FILTER ( <YOUR SUMMARIZED TABLE>, [ItemQty] <> 0 ).

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian