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...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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.

Remove_values_from_totals

 

 

Best Regards,

Dale

Anonymous's avatar
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?

 

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    Could you please share a sample and the expected result?

     

    Best Regards,

    Dale