Get column total and percent of column

[deannapi]

I created a matrix of 2 categories and an ID column - the ID column will be used in the "Value" but as COUNT DISTINCT. 

I want a measure to insert in between all columns of the matrix that show the % of each row

Example: 

	ColumnB Item1	% of Total
ColumnA Item1	4	4/13 = 30.77%
ColumnA Item2	9	9/13 = 69.23%
Total	13	100%

Here is what I've tried and my values are grouped by ColumnA, ColumnB, and date.

% of Volume = 
VAR totalbyOrigin =
    SUMMARIZE (
        TableA,
        TableA[ColumnA],
        TableA[DateCreated],
        TableA[ColumnB],
        "% of Volume", DISTINCTCOUNT ( TableA[ID] )
    )
RETURN
    DIVIDE (
        totalbyOrigin,
        CALCULATE ( DISTINCTCOUNT ( TableA[ID] ), ALLSELECTED () )
    )

 I get the following error message:

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

[deannapi · Accepted solution]

solving my own problem: 

% of Volume = 
VAR totalbyOrigin =
    SUMMARIZE (
        TableA,
        TableA[ColumnA],
        TableA[DateCreated],
        TableA[ColumnB],
        "Volume", DISTINCTCOUNT ( TableA[ID] )
    )
RETURN
    DIVIDE (
       SUMX( totalbyOrigin, [Volume]), 100
    )

THen I added this to my matrix and selected "percent of column".