Measure with customized totals

Hi Anonymous ,

Please try using ISINSCOPE() or ISFILTERED() function.

https://docs.microsoft.com/en-us/dax/isinscope-function-dax 

https://docs.microsoft.com/en-us/dax/isfiltered-function-dax 

It will return TRUE in commen rows and return FALSE in total row.

So that you will need to create separate calculations for common rows and total row.

Return total calculation when false and return common calculation when true, like:

Measure = 
var common = [common]

var total = [total]

return
IF(ISINSCOPE([column]),[common],[total])

Best Regards,

Jay