Forum Discussion

Sonam_Pillai's avatar
Sonam_Pillai
Icon for Helper I rankHelper I
6 years ago

How to exclude values

  I have data like this:   Cities Criteria Value Mumbai Criteria1  376 Mumbai Criteria2  null Chennai Criteria1  471 Chennai Criteria2  254 Delhi Criteria1  null D...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Sonam_Pillai , You can use visual level filter

 

Or measure like

Calculate(sumX(filter(table,table[city]<> ,"Delhi" Table[value]))

  • Sonam_Pillai's avatar
    Sonam_Pillai
    Icon for Helper I rankHelper I
    6 years ago

    Thank you. amitchandak 

     

    This is working in table graph but i am not able to convert the same table into Clustered chart.

     

    how to do it?