Forum Discussion

deeksha's avatar
deeksha
Icon for Helper II rankHelper II
6 years ago

Remove total from the measure

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 f...
Need Help
sspulsifer's avatar
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's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity 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])