topic Re: display issue in DAX Commands and Tips

display issue

Nihed — Thu, 17 Feb 2022 12:25:16 GMT

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?

Re: display issue

amitchandak — Thu, 17 Feb 2022 12:33:24 GMT

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

Re: display issue

ValtteriN — Thu, 17 Feb 2022 12:33:33 GMT

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/

Re: display issue

Anonymous — Thu, 17 Feb 2022 13:14:41 GMT

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

Re: display issue

v-jingzhang — Tue, 22 Feb 2022 02:19:45 GMT

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