Solved: Re: partial access on dataset

1Daniel993 · ‎12-14-2022

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

Anonymous · ‎12-14-2022

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:

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.

Anonymous · ‎12-14-2022

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:

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.

partial access on dataset