Forum Discussion

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

Not applicable

8 years ago

Hi again v-jiascu-msft

I can't get the measure to work.

The idea is to exclude items that have value "<5".

Registration dato is actually registration date, and it seems like the measure won't work.

Should I do a count initially? or perhaps do something differently? For instance, looking at this table. I won't to format the numbers to be <100 and not be accounted for in the totals. Is that possible?