display error
1 Topic
Percentage Calc Not Displaying - Not Sure Why
Morning, I am using the below calc to show the prevalence of one value, within a set of another values. For example, if I visit ten houses over the year and find five of these items, my prevalence rate for the year should be 50%. The calc appears to work but when I drag it onto the graph to display as Line Value I get a "Can't Display the Visual Error". As you can see I'm simply "Sum"-ing the column "Sev1 Sum Post Appeal" and getting that Sum Total to appear as a percentage of the total rows (one row = one property visited). Any ideas? Calc Overall Inspection Result Sev1 Prevalence = DIVIDE( COUNTROWS('EXTRACT') , SUM('EXTRACT'[Sev1 Sum Post Appeal]) , BLANK() )Solved929Views0likes3Comments