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
Community 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.