Forum Discussion

Mart's avatar
Mart
Icon for Advocate IV rankAdvocate IV
9 years ago

Pecentage in a matrix with grouping Help

using this: percent = DIVIDE(SUM('Table1 (2)'[People]), CALCULATE(COUNT('Table1 (2)'[People]),ALLEXCEPT('Table1 (2)','Table1 (2)'[People])))   I was able to get a percentage but the calculation ne...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

Mart

 

hi, you need to modified the AllExcept, Just mantain the filter Group and it works

 

% =
    DIVIDE (
        CALCULATE ( COUNT ( Table1[People] ) ),
        CALCULATE ( COUNT ( Table1[People] ), ALLEXCEPT ( Table1,Table1[Group] ) )
    )
Mart's avatar
Mart
Icon for Advocate IV rankAdvocate IV
9 years ago

Thanks Victor

 

Almost there but percentage still wrong after first total row, you can't have more than 100%

 

Will try to upload new image