display issue

[Nihed]

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?

[v-jingzhang]

Hi @Nihed 

Did other replies solve your problem? If it's solved, please accept a helpful reply as Solution. If not, please share some dummy data to help us understand it better.

E.g. Are "M CCY" and "M EUR" columns or measures? If they are columns, what is the table structure of the original data table? If they are measures, share their formula. The solutions will be different in both scenarios.

Best Regards,
Community Support Team _ Jing

[Anonymous]

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

[ValtteriN]

Hi,

Try something like this:

Onlytotal for value2 = IF(not(ISFILTERED('Matrix example'[Item]))&&SELECTEDVALUE('Matrix example'[Material])="Wood",SUM('Matrix example'[Value2]),BLANK())

This DAX will only show total values for material "wood" you can utilize same logic to create the measure you want.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[amitchandak]

@Nihed , Assume you do want display total of  M CCY - Assuming it is measure

a new measure =

if(not(isinscope(Table[Currency key])), Blank(), [M CCY])