partial access on dataset

Hi 1Daniel993 ,

As far as I know, if you create a measure based on SUM()/SUMX() function, there will be subtotal in table / matrix visuals.

You can use sum to sum the columns and sumx to sum the measure.

For reference: 

SUM function (DAX) - DAX | Microsoft Learn

SUMX function (DAX) - DAX | Microsoft Learn

Best Regards,
Rico Zhou

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