Show table total only when all Currencies are the same

[kartiklal7]

Hi All, 

I'm representing certain metrics in a table in Power BI. For the columns "Estimated Annual Renewal Amount in Currency" and "Transacted Annual Amount in Currency" I only want to show the total at the bottom when the Currency is the same in every row. If there is a mix of currencies like in the screenshot below I do not want to show a total for these columns. 

Is there a way to do that? 

[johnt75]

You can use HASONEVALUE, like

Measure Name = IF( HASONEVALUE( 'Table'[Currency]), 
Current measure definition
)

[kartiklal7]

@johnt75 ,

Thanks for the reply.

Your solution works but it slows down the performance of the table significantly. Is there another more efficient way to do this? 

[johnt75 · Accepted solution]

If you have a unique row in the table visual, e.g. Category, then you could try

Measure name = 
var currentValue = current measure definition
return IF( ISINSCOPE( 'Table'[Category]), currentValue,
IF( HASONEVALUE( 'Table'[Currency]), currentValue)
)