Equivalent of HAVING in DAX

Anonymous — Fri, 09 Feb 2024 18:52:34 GMT

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)) )

Re: Equivalent of HAVING in DAX

barritown — Fri, 09 Feb 2024 20:41:54 GMT

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

topic Re: Equivalent of HAVING in DAX in DAX Commands and Tips

Equivalent of HAVING in DAX

Re: Equivalent of HAVING in DAX