How can i convert this DAX function into Quicksight ?
“C31 PO QTY = SUMX(FILTER(‘ALL SUPPLY’,‘ALL SUPPLY’[ITNO] = ‘CO/DO’[ITNO - Item number]),‘ALL SUPPLY’[TRQT - Transaction quantity - basic U/M])”
Hi Hemant,
Can you please describe what computation you are trying to built. May be a sample subset of data and expected output will help us to understand your requirement and recommend some solution.
You can optionally use Quick Sight Arena (QuickSight Arena -- An embedded instance of QuickSight within the Community) to provide sample dataset masking any sensitive data.
Regards,
Anwar Ali
i mean what is the replacement for SUMX(Filter) in Quicksight?
Hello @Hemant_rangdal, I checked out the SUMX function, and while I do not think they are exactly the same, I believe the sumOver function is likely the closest alternative in Quick Sight. It will allow you to get the sum of a value related to a specific partition field in your dataset. I’ll link the documentation below:
I will mark this as a solution, if you have further questions about implementation, please let me know!