Forum Discussion

Idigorasu's avatar
Idigorasu
Frequent Visitor
6 years ago
Solved

Ingore specific values on measure

Hi,   I have a list of names taken from a SharePoint list. Laura Ana Mark John I want to somehow (I'm guessing using a measure), ignore a specific value, for example Mark, so the list will b...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Edit query -> Click on this colummn -> uncheck the check box before required name.

     

    another way is

     

    new measure= if(max(table[Name])="Mark",1,0)

    add this measure to visual level filter and set it to 1.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Edit query -> Click on this colummn -> uncheck the check box before required name.

 

another way is

 

new measure= if(max(table[Name])="Mark",1,0)

add this measure to visual level filter and set it to 1.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.