How to set the custom value to Total row?

[TarasHrytsak]

Hello, I have a table with the total, how I can set custom values to the total row?

[amitchandak · Accepted solution]

@TarasHrytsak , Yes use isinscope or isfiltered if needed

Use for all the rows in if and do for each

for each measure

if(not(isinscope(Table[Month])), [Total measure], [Target revenue])

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/