Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.