Converting DAX to MDX

Hi Justas4478 ,

Are you saying here:

Here I created a Calculated member called [Measures].[DaysShorted] to count the number of non-zero Shorted Qty entries.

If this doesn't work, you can try this one:

WITH 
MEMBER [Measures].[ShortedQty] AS 
    [Measures].[Shorted Qty]

SET [ShortedTable] AS 
    NONEMPTY(
        [Product Category].[Level 2].MEMBERS *
        [Date].[Date].MEMBERS,
        [Measures].[ShortedQty]
    )

MEMBER [Measures].[FilteredShortedQty] AS
    SUM(
        FILTER(
            [ShortedTable],
            [Measures].[ShortedQty] <> 0
        ),
        [Measures].[ShortedQty]
    )

MEMBER [Measures].[CountFilteredShortedQty] AS
    COUNT(
        FILTER(
            [ShortedTable],
            [Measures].[ShortedQty] <> 0
        )
    )

SELECT 
    [Measures].[CountFilteredShortedQty] ON COLUMNS,
    NONEMPTY([Date].[Date].MEMBERS) ON ROWS
FROM [YourCubeName]

But to be honest, sometimes it is difficult to convert directly from DAX to MDX. If it is still incorrect, perhaps you need to provide your data and explain what you want to accomplish with DAX/MDX.

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