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?  
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/