Remove values from totals

[Anonymous]

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(count('Antal'[Registrerings Dato]);"")).

This made all values less than 5 be "<5" but it does not change the totals.

[v-jiascu-msft]

Hi @Anonymous,

What's the expected result?

1. If you want to exclude these items that have value "<5", you can try a measure like this:

Measure =
SUMX (
    'Antal';
    IF ( 'Antal'[Registrerings Dato] < 5; 0; 'Antal'[Registrerings Dato] )
        < 5
)

2. If you want to exclude these items that have presence "<5", you can use your formula and filter them out in the visual level filter.

Or, you can share your data model and the expected result.

Best Regards,

Dale

[Anonymous]

 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?

[v-jiascu-msft]

Hi @Anonymous,

Could you please share a sample and the expected result?

Best Regards,

Dale

[Anonymous]

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.