Forum Discussion
partial access on dataset
Is there a way to be able to review the total numbers of a measure if you have partial access to the database?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.