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

Hi Anonymous 

try a measure, not calculated column

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

     

    Quoting:

    "Limitations in calculated columns: Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions. Additionally, the DAX scalar functions, such as LEFT(), that are allowed, are limited to those functions that can be pushed to the underlying source. The functions vary depending upon the exact capabilities of the source. Functions that aren't supported aren't listed in autocomplete when authoring the DAX for a calculated column, and would result in an error if used."