Battling to get a cubeset to sort correctly
Good afternoon everyone I am new here & this is my first post. I have been searching the web & have not managed to find a solution to my problem. Using the following formula, I am able to get the correct list of suppliers, but I am wanting to sort the list based on Units for the whole period (12 months). =CUBESET("ThisWorkbookDataModel","Except(Filter(EXISTS([OCR_VW_RPT_OCR].[PARENT_SUPPLIER_NAME].MEMBERS,[OCR_VW_RPT_OCR].[RETAINED_MONTH].[01 Aug 2024].lag(11):[OCR_VW_RPT_OCR].[RETAINED_MONTH].[01 Aug 2024]),[Measures].[EACT UNITS]>0),[OCR_VW_RPT_OCR].[PARENT_SUPPLIER_NAME].[All])","PARENTSUPPLIERNAME",2,"[Measures].[EACT UNITS]") Can anyone spot the syntax error or is there maybe a different way/method of doing this? My generated list matches my manually created list perfectly, but the sort does not. Any help on this would be highly appreciated. Thanks, Darryll