Give attributes to a measure in DAX for filtering

[Anonymous]

Hello,

I am stuck with a DAX problem. I have 2 tables:

- "Cath" table with one column called "Types" => Cath[Types] :

It contains all the differents type of items.

- I have an other table "Items" containing all kind of datas such as type, measure, price... :

I created thanks to DAX a calculated culumn which give me the "NDT" values.

I have a relationship between Items[Type] and Cath[Types]. I display my informations in a matrix like below. I can use several filters to display the needed informations :

What I'd like to do is to attribute "type" = "NDT" to my NDT values in the Cath[Types] column so when I filter on Cath[Type] = "NDT", it should display NDT sum.

Could some one help me ?

Thanks

[Fowmy]

@Anonymous 

Didn't quite get what you are trying to achieve. Can you explain and how the expected result?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

[Anonymous]

Hello, thanks for answering.

I'm trying to sum up : 

I have this data table :

Thanks to DAX, I creat a calculated column "NDT" like this :

In my repport, I have a matrix displaying quanties for each type of items :

link to a "type" filter :

What I want to do is to have my "NDT" displayed in my matrix like this :

When I click on NDT in my filter, I should have only NDT displayed. My problem is that NDT values come from a calculated column. The values are not linked to "NDT" type. 

Is that more understantable ?

Thanks !