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.
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Looks like I will need to see your data.

Is it possible to share your pbix file?

 

Thanks,

Pragati

  • 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.