Forum Discussion
Isfiltered is not working properly
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.
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.
7 Replies
- Pragati11
Super User
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
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
