Forum Discussion

deadlycapybara7's avatar
deadlycapybara7
Frequent Visitor
9 years ago
Solved

% GT over two columns

Hi,   I'm a complete novice on Power BI but I'm trying to combine two columns with similar data (e.g. 1-5) to create a GT% overall.   e.g. Count A contains different number of 1-5 data than Count...
Need Help
  • Twilla's avatar
    Twilla
    9 years ago

    Hi,

     

    Create a measure:

     

     

    % of GT = sumx(Table1;Table1[Count A]+Table1[Count B])/calculate(SUM(Table1[Count A])+SUM(Table1[Count B]);all(Table1))

    Replace table1 with the name of your table.

     

    The sumx function takes the sum of count A and count B at row level.

    The second part takes the sum of count A+count B for the whole table (it does this because we use a the "ALL" function which ignores the current context of the row. For you to understand the solution, search some info about the DAX functions: All, Calculate, SUM and SUMX.

Twilla's avatar
Twilla
Helper I
9 years ago

Hi,

 

Create a measure:

 

 

% of GT = sumx(Table1;Table1[Count A]+Table1[Count B])/calculate(SUM(Table1[Count A])+SUM(Table1[Count B]);all(Table1))

Replace table1 with the name of your table.

 

The sumx function takes the sum of count A and count B at row level.

The second part takes the sum of count A+count B for the whole table (it does this because we use a the "ALL" function which ignores the current context of the row. For you to understand the solution, search some info about the DAX functions: All, Calculate, SUM and SUMX.