Isfiltered is not working properly

[Anonymous]

Hi All,

I have used the Column chart Which showing Gross Margin % by Department and Items.

Default we need to show the Department level and then drill down to Item level.

We have also added the Lower and Upper bound as Tooltip, but on one condition, the lower and upper bound can show only at Item level and not at the department level.

So I have used the following measure for upper and lower

1. Lower = IF(IS FILTERED(Items[Items]), CALCULATE([Lower Bound],ALL(Items[Items])))  (same for the Upper)

The output showing correctly as expected, but the problem here is that when I have select any item from the Items slicers, the upper and lower values we can see at the department level also and which is not expected.

Please help me on this, the lower and upper values only shown in Items level and not in department level

Please help me on this, the lower and upper values only shown in Items level and not in department level

Thanks.

[Pragati11]

Hi @Anonymous ,

Just convert your calculations for LOWER as follows:

 Lower = IF(IS FILTERED(Items[Items]), CALCULATE([Lower Bound], ALLSELECTED(Items[Items])))

Do same for UPPER as well. (Replace ALL with ALLSELECTED in your dax expression)

Thanks,

Pragati

[Anonymous]

Hi @Pragati11,

Thank you for the quick reply,

I am changing the measure as you suggested, but still, I can see the Lower and Upper tooltip in Department level when selecting some items from Items slicers

[Pragati11]

Hi @Anonymous ,

Try this chnage:

Lower = IF(IS FILTERED(Items[Items]), CALCULATE([Lower Bound], ALLSELECTED(Items)))

Thanks,

Pragati

[Anonymous]

Hi @Pragati11,

No, still I can see the tooltip at department level only when Items selected from Items slicer.

Thanks,

[Pragati11]

Hi @Anonymous ,

Looks like I will need to see your data.

Is it possible to share your pbix file?

Thanks,

Pragati

[Anonymous]

Hi @Pragati11,

Please find below the .pbix file

https://sparinformation-my.sharepoint.com/:u:/g/personal/atul_patil_sparinfosys_com/EaUr-Xpg_9dGrbna...

Thanks

[Anonymous · Accepted solution]

Hi All, @Pragati11,

I have solved this issue, we can use Hasonefilter instead of isfiltered

I have used the following measure

Lower = IF(HASONEFILTER(ItemsCost[Items]), CALCULATE([Lower Bound],ALLSELECTED(ItemsCost[Items])))

and it is working.

Thanks.