Measure filter

[Companyuser101]

Hello, I have the field "Ziel AG (WHS)" which is a Sum. 

I now want fo filter it with a measure. You see on the picture above that the Field Ziel AG WHS appears on on every line. I only want it to appear for "Agricultural Tractor". Can I write a measure to filterit? I tried it with the calculate measure, but it did not work. 

[v-yanjiang-msft]

Hi @Companyuser101 ,

According to your description, you want only the previous level to display values and the next level not. I create a sample.

And a measure to reproduce your problem.

Here's my solution, create another measure.

Measure2 =
IF ( ISINSCOPE ( 'Table'[Sub_category] ), BLANK (), [Measure] )

Then get the expected result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Companyuser101]

Hey, thanks for your help!

Sadly it did not work with my data. Our data is a litte more complex. 

I want to provide you with some data, but I can't upload it here. 

For explanation we have two data sets. 

1) Products: 

This are all our products. We have four categories (hierachy L1) and then different series of this categories and for all series specific models. Its a hierachy. 

Then we have our goal data. 

We only make goals for the hierachy L1 level.

I have a relation between those two datas with hierachy L1.

We have different dealers, in this example 3. All have goals in Retails and WholeSales for Prod. Hierachy L1. 

I have a relationship between these two data sets on Prod. Hierachy l1. 

My table then looks like this: 

I have a second data set. products are the same. 

But I put in the goal data some Prod. Hierachy L3. These are wrong, just manipulated it, because maybe PowerBi needs data there.

Goal data now looks like this: 

I have now a relationship on prod. hierachy L3

Data now looks like this: 

Maybe this can help you. Maybe PowerBi need data for hierachy L3 because its the lowest in the hierachy. Just an idea of mine. 

Thanks for your help!

[ToddChitt]

I bet that field is not related to rows you show, because it is showing 13 for each, event he total. Can you share your data tables and relationships?

[Companyuser101]

Hi, yes there is no relationship. In the "Ziel" data we dont have columns that could relate to the "model" date which ist agricultural date, compact tractors, and so on. 

[Companyuser101]

Hello again, 

I changed the data a little bit: 

Now I have a relationship: 

My table now looks like this: 

The WHS Plan now is correct for the different models (Agricultural Tractor, Compact Tractos, ...).

But I'm not able to make a relationship with the second dimension 

So here are still always the same numbers. 

Can I filter the numbers from WHS Plan so they only appear on the first dimension and not on the following ones?