Measure to calculate percentage

[Jigar1276]

Hi,

I am using following measure and used it in "Total" column in a table:

#Cases = DISTINCTCOUNT('Board'[key])+0

I want to add one more column in the same table to show the %. I am able to do it in Excel:

I need help to achieve the same in PBI. 

[Jigar1276]

Thanks a lot @johnt75, it worked as desired.

[johnt75 · Accepted solution]

You can create a measure like

% =
VAR CurrentValue = [# cases]
VAR Total =
    CALCULATE ( [# cases], ALLSELECTED ( 'Table'[Client] ) )
RETURN
    DIVIDE ( CurrentValue, Total )