Forum Discussion
Solved
Exclude blank data from calculations
Hello, In the following table, I'm trying to exclude blank values from my calculation for Rate per SF so that my total Rate per SF isn't including all the job size numbers in the denominator, but...
jwarner1121 Try something like:
Measure = VAR __Table = FILTER( SUMMARIZE( 'Table', [Estimate Code], [Item Code], "__JobSize",[Job Size], "__ItemCostTotal",[Item Cost Total] ), [__JobSize] <> BLANK() ) VAR __Result = DIVIDE(SUMX(__Table,[__ItemCostTotal]), SUMX(__Table,[__JobSize]),0) RETURN __Result
Thanks for your help!