Forum Discussion

Nihed's avatar
Nihed
Icon for Helper III rankHelper III
4 years ago

display issue

Hello, I have the following table in power BI and I wanted to display only the "M EUR" total how I can do it please?  
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Nihed ,
What I understand is that you want this result 

This can be achieved by making this measure :

M EUR only Total = 
IF(
    ISINSCOPE('Table'[Currency key]),
    BLANK(),
    SUM('Table'[M EUR])
)

 

 

Regards