I want to show only the above 10M values in the table

[jade]

Hi. Can someone help me? I wanted to show only the amounts more than 10M. This is my expression If (Sum([Project Value, Total])>10000000, Sum([Project Value, Total])), but it also shows the data that is less than of 10M. Please refer on the picture below.

[QFabian]

Hi @jade , if your chart table have morte than one expression, the if must be in every column expression

[anat]

Apply suppress zero or null values but it may impact other expression values also

[Lisa_P]

If this is the first measure you can use the dimension to limit the values under dimension limits (based on the first measure) to the following