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.

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