Forum Discussion

hibarrbm's avatar
hibarrbm
Helper I
6 years ago

Transform SQL Formula Into DAX Measure For Total Sales

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!

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

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