Hi,I have created a measure to calculate the sales revenue, but I do not want the total in the report, and in the other measures too, i don't want the total in the report, How to remove the total for the measur

Hi, You can disable the total in the visualization objects you are using. For examle, in a matriz: If it helps, pls give a kudo and mark as the solution. Thanks

Use the ISINSCOPE function. Say you have a field ina visual which is Table[Category] and a measure for [Sum Sales]. You can exclude totals by using a measure along the lines of: Exclude totals = IF(ISINSCOPE (Table[Category]), [Sum Sales])

If you want a quick fix to not show the total of only 1 column. Go to visual settings > specific column > only check the: Apply on total > make the text color the same as your background (probably white). Now the total is still there, you just can't see it.

but there is no option of subTotals.

Hi, Which visualization object are you using (chart, matrix, etc)? Did you click on it and navigate on the Visualization pane as I a shown and the last post?

Remove total from the measure | Microsoft Fabric Community

11 Replies

mauriciosotero
Resolver III
6 years ago
Hi,

You can disable the total in the visualization objects you are using. For examle, in a matriz:

If it helps, pls give a kudo and mark as the solution. Thanks
- deeksha
  Helper II
  6 years ago
  but there is no option of subTotals.
  - mauriciosotero
    Resolver III
    6 years ago
    Hi,
    
    Which visualization object are you using (chart, matrix, etc)? Did you click on it and navigate on the Visualization pane as I a shown and the last post?
Anonymous
Not applicable
3 years ago
If you want a quick fix to not show the total of only 1 column. Go to visual settings > specific column > only check the: Apply on total > make the text color the same as your background (probably white).
Now the total is still there, you just can't see it.
- JeanSodre
  Regular Visitor
  2 years ago
  Really clever ! It helped me a lot !
  Thanks
sspulsifer
Frequent Visitor
4 years ago
Has anyone found how to do this for measures? I can choose "Don't summarize" for data fields, but it doesn't appear as an option for measures.
- PaulDBrown
  Community Champion
  4 years ago
  Use the ISINSCOPE function. Say you have a field ina visual which is Table[Category] and a measure for [Sum Sales]. You can exclude totals by using a measure along the lines of:
  
  Exclude totals = IF(ISINSCOPE (Table[Category]), [Sum Sales])

Forum Discussion

Remove total from the measure

11 Replies

Related content

% of total measure

Total of Measure

Measure Total Incorrect

Measure Total, again

Remove totals in matrix table