Transform SQL Formula Into DAX Measure For Total Sales

hibarrbm — Wed, 12 Aug 2020 19:12:36 GMT

Hello,

I have a SQL formula from SQL Developer that i'm trying to translate into DAX measure formula. Its taking orders from a fact table that status key = (25,133) then from another fact table with a filter and finally if true then sum the price from the third table.

Here is the formula i have from SQL Developer:

Sum( case when ODS_OWNER.FACT_FULFILLMENT.FULFILLED_STATUS_KEY in(25,133) then (

case when (DECODE(BITAND(ODS_OWNER.FACT_ORDER_LINE.ORDER_LINE_FLG, POWER(2 , 0)),POWER(2 , 0), '1', '0')) = 1 then 0

else ODS_OWNER.FCT_SHIP_GRP_ITEM.FULFILLMENT_ITEM_PRICE

END) else 0 end )

Any help is appreciated!

Re: Transform SQL Formula Into DAX Measure For Total Sales

lbendlin — Wed, 12 Aug 2020 23:20:33 GMT

That is some really deep PLSQL...

Bitand(ods_owner.fact_order_line.order_line_flg, Power(2, 0))

Isn't that just checking if fact_order_line_flg is an odd number? You can use the MOD function for that. The equivalent for Decode seems to be COALESCE()

topic Transform SQL Formula Into DAX Measure For Total Sales in DAX Commands and Tips

Transform SQL Formula Into DAX Measure For Total Sales

Re: Transform SQL Formula Into DAX Measure For Total Sales