Showing Measure Only In Total Column

[ShrimpCreole]

How do you show a measure only in the total column?

For example, in a financial statement I wish to show monthly total revenue by account, but only show % of total revenue in the YTD total column.

Thank you!!!

[v-yalanwu-msft]

Hi, @ShrimpCreole ;

Is your problem solved? DataInsights's reply is correct. and if you could post the sample data and expected output,It makes it easier to give you a solution.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DataInsights · Accepted solution]

@ShrimpCreole,

You can use HASONEVALUE or ISINSCOPE to identify a total column, and display the measure accordingly.

https://www.sqlbi.com/articles/distinguishing-hasonevalue-from-isinscope/