Calculate % of an item, rounded to 3 decimal places

ROUND( -- round to 3 decimal places CALCULATE( COUNTROWS(<table_name>), FILTER ( <table_name> -- the table to be filtered , <column_name> = "..." || <column_name> = "...")) -- expression to be evaluated for each row / COUNT(<column_name>) -- count of all rows, could also use COUNTROWS() , 3) * 100 & " %"