Forum Discussion

Nihed's avatar
Nihed
Helper 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?

 

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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])

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    4 years ago

    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/

  • 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

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    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