if count (#) is less than 5 then row values should be shown as "Other Factors"

[Niharika24]

i have the matrix table , i want that if count (#) is less than 5 then row values should be shown as "Other Factors"

else the original value (row headers)

[Anonymous · Accepted solution]

Hi @Niharika24 ,

Do you want to show the areas marked in red in the image below as "Other Factors"? 

If so, the field or calculated column that was previously applied to the Values field options will become a Text type. You can create or update your calculated column as follows.

Measure=if(count(#)<5, "Other Factors",count(#))

In order to be able to provide you with a suitable solution, could you share some sample data(exclude sensitive data) of these fields applied to the matrix? If the calculated column is applied on the Values options of the matrix, please share the formula for the calculated column as well.

Would you consider using conditional formatting feature? For example, if count (#) < 5, use red for the background color and keep the original background color for the rest.

Best Regards

[amitchandak]

@Niharika24 , if count # is a measure example count(Table[Column])

then a new measure

if([count #] < 5, Other Factors", [count #] &"")

Ir will make it text , use format function to format count#, if needed

[Niharika24]

Please help

[Niharika24]

i have atatched the screenshot , kindly if you can help me with details to be taken for measure