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

Hi Anonymous ,

 

Try this to create a measure:

Percentag =
VAR dr =
    CALCULATE ( SUM ( 'ABCR_Consolidated_View'[Final_Count] ) )
RETURN
    IF ( dr = 0, BLANK (), MAX ( 'ABCR_Consolidated_View'[Delta] ) / dr * 100 )

 

Please tell me if it works.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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] ) )