Forum Discussion

Chrisjr's avatar
Chrisjr
Icon for Helper IV rankHelper IV
3 years ago
Solved

Display values on graph only when selection has been madse on multiple filters

Hello All,    I have the following problem:   I want a graph to display values only when values have been selected on both filtered but it won't work.    Here is an example:    1. The current ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Chrisjr , Change and && to OR || as per need in given measure

     

     

    measure =var _1 = int(calculate( ISFILTERED('LOOKUP'[promo type]) ,allselected()))
    var _2 int(calculate( ISFILTERED(Competitors[competitor]) ,allselected()))
    return
    if(_1= 1 && _2=1, 1,0) 

Chrisjr's avatar
Chrisjr
Icon for Helper IV rankHelper IV
3 years ago

Thanks a lot amitchandak , it works fine 🙏🙏