Divide individual values and total of same column in direct query

[benqpbi]

I have a column named comp_records, i want to divide the comp_record/total_comp_record --- which is 34
i am using direct query, could you pls help.

[DOLEARY85 · Accepted solution]

Hi,

use this:

Measure = DIVIDE(CALCULATE(SUM('Table Name'[comp_record])),CALCULATE(SUM('Table Name'[comp_record]),ALL('Table Name')))

[Evanooruvan]

lets say i have one more column named level which has values 1,2,3,4,5,6.
i want the measure to calculate values only if we have level - 4,5,6

[DOLEARY85]

You could try:

Measure =

DIVIDE(CALCULATE(SUM('Table Name'[comp_record]),or('Table Name'[level]=4,or('Table Name'[level]=5,'Table Name'[level]=6))),CALCULATE(SUM('Table Name'[comp_record]),ALL('Table Name'[comp_record])))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Anonymous]

try this measure 

Measure = SUM('Table'[comp_records])/CALCULATE(sum('Table'[comp_records]),all('Table'[comp_records]))