partial access on dataset

[1Daniel993]

Is there a way to be able to review the total numbers of a measure if you have partial access to the database?

[Anonymous · Accepted solution]

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.