[Need Help] How to Sum Values in subtotal based on Column/Row with CountDistinct formula

Hi utsurur ,

You can try this measure.

#_D Mobile + Wifi =
SUMX (
    CROSSJOIN (
        VALUES ( 'Table'[Matrix Row Field] ),
        VALUES ( 'Table'[Matrix Column Field] )
    ),
    CALCULATE (
        CALCULATE (
            DISTINCTCOUNT ( f_mw_202301_202404[device_id] ),
            FILTER (
                f_mw_202301_202404,
                f_mw_202301_202404[category] = "Buy"
                    || f_mw_202301_202404[category] = "Use"
            )
        )
    )
)

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~