Forum Discussion

Sam1002's avatar
Sam1002
Regular Visitor
4 years ago
Solved

Dax for Summarized table on a condition

Hello, I needed help with writing a Dax for summarized table on a condition, meaning with a condition is true group the records and if condition is false don't group the records.    In below exampl...
ALLEXCEPT
groupby
summarize table
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Sam1002 

    Try to create a calculated table like this:

    Table 2 = 
SUMMARIZE(
    'Table',
    [Service Folder],[TRANSFERID],[ITEMID],[RMC Base],[WorkStatus],
    "CREATEDDATETIME",MAX('Table'[CREATEDDATETIME]),"WorkClosedDateTime",MAX('Table'[WorkClosedDateTime]),"QTYTRANSFER",SUM('Table'[QTYTRANSFER]),
    "QTYRECEIVED",SUM('Table'[QTYRECEIVED]),"QTYREMAINSHIP",SUM('Table'[QTYREMAINSHIP])
    )

    Result:

    Please refer to the attachment below for details.

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Sam1002 

Try to create a calculated table like this:

Table 2 = 
SUMMARIZE(
    'Table',
    [Service Folder],[TRANSFERID],[ITEMID],[RMC Base],[WorkStatus],
    "CREATEDDATETIME",MAX('Table'[CREATEDDATETIME]),"WorkClosedDateTime",MAX('Table'[WorkClosedDateTime]),"QTYTRANSFER",SUM('Table'[QTYTRANSFER]),
    "QTYRECEIVED",SUM('Table'[QTYRECEIVED]),"QTYREMAINSHIP",SUM('Table'[QTYREMAINSHIP])
    )

Result:

Please refer to the attachment below for details.

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Sam1002's avatar
    Sam1002
    Regular Visitor
    4 years ago

    Hello v-angzheng-msft 

    This worked really well. Thank you for the efforts 🙂