Unable to get cubeset to sort properly

[JV0710]

Good Day

Please can I get some help with the following Cube Set problem

I have a PowerPivot file where I have the following cube set which works in that it creates the list but it does not sort properly. In the cube set I am referring to a period of time (selected date, lag : selected date). I am suspecting that I am not grouping the dax statement properly but everything I am trying is not working:

=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]")

The result is that I get a list of 670 suppliers which is correct, but when I write the cube values to get the data the result is not sorted descending as per the cube set

Would appreciate any help please

 

[JV0710]

The pic attached is shows a snippet of the result I am getting where the numbers are not sorted