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

 

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

 

 

4 Replies

  • 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. 

  • 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