Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    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] ) )
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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] ) )
Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.

 

 

Best Regards,

Icey