Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Remove values from totals

Hi. I am trying to create a measure to exclude all values less than 5.  Would this be possible?     I tried to make this measure: Measure= if(COUNT('Antal'[Registrerings Dato])<5;"<5";format(coun...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello.

 

I am trying to create a measure to remove numbers less than 5 from totals.

I created this measure: Measure1= if(COUNT('Antal'[Registrerings Dato])<5;"<5";format(count('Antal'[Registrerings Dato]);""))

 

This measure changes all values less than 5 to "<5" but you can still calculate the totals.