topic Re: Value just for specific Total Number and 0 for specific Values in DAX Commands and Tips

Value just for specific Total Number and 0 for specific Values

joshua1990 — Thu, 03 Feb 2022 12:05:33 GMT

Hi experts!

I have a transactional table that contains a lot of Sales Values for each product.

This table is linked to a dimensional table that contains the department level.

Now, I would like to display the sales for each department and each product in a simple matrix.

But, there is 1 department, where I would like to get the Sales Value just for the Total / Subtotal, and a 0 for the Products.

How is this possible using DAX?

ValtteriN — Thu, 03 Feb 2022 12:25:01 GMT

Hi,

You can use ISFILTERED to display certain level as 0. For example:

IF(ISFILTERED('Matrix example'[Material])&&MAX('Matrix example'[Item])="Item1",0,1)

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/