Forum Discussion

Companyuser101's avatar
Companyuser101
Helper II
4 years ago

Measure filter

  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 on...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

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's avatar
Companyuser101
Helper II
3 years ago

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!