Forum Discussion
Calculated column for direct query
I have View from direct query ,based on two columns i'm calucating percentage using the below formula Percentag = var dr=CALCULATE(sum('ABCR_Consolidated_View'[Final_Count])) return if(dr=0,blan...
Icey thanks for the solution
In my case I'm getting some error so i used the divide function to solve the problem.
Delta1 = DIVIDE ( SUM ( 'ABCR_Consolidated'[Delta]), SUM ('ABCR_Consolidated'[Final_Count] ) )
Columns are nor supported. Measures are. Refer my article how to handle these look for net sales , gross sales, and discount