Percentages in Category calculates incorrectly, but percentages in Total column calculate correctly

[Gabe_V]

I have a matrix in Power BI that looks like the following:

I have a DAX measure that calculates Percentage of Active for each column as follows:

Percentage of Active = DIVIDE(
    COUNT('Project Status Report'[Project ID]),
    CALCULATE(COUNT('Project Status Report'[Project ID]), FILTER(ALLSELECTED('Project Status Report'),'Project Status Report'[Project Status]="Active")
    ))

My problem is that although the Percentage of Active calculates correctly for the Total column, it doesn't calculate properly for any of the other columns. For example: For the "Green" row, 7 in Total Combined Column divided by 11 in the Total row in the Total Active Column, converted to % provides the correct value of 63.64%. However, for the same "Green" row in the Control Center Column, a 6 in the Control Center Combined Column divided by 10 in the Total Row of the Control Center Active column, converted into a %, results in an incorrect value of 54.55% when it should have been 60%.

Does anyone have any idea how to fix this?

Considering I really care most for the Total column, if there is a way to hide "Percentage of Active" in all columns except the Total column in the matrix, that would be even better.

Any help is greatly appreciated, thank you! 

[Anonymous]

Hi, @Gabe_V 

Thanks for lbendlin's reply. Obviously, this problem results because of 6/11, not 6/10, and you can provide pbix files without sensitive data for testing. Unfortunately, the current version of PBI desktop's matrix does not support displaying only the Total Combind columns.

Best Regards,
Yang
Community Support Team

[Gabe_V]

Thank you for that clarification, @Anonymous . I wasn't able to figure out how to get it to divide by the individual column total as opposed to the grand total.

[lbendlin]

Disable word wrap for the column headers

Disable auto sizing for the column headers

Disable word wrap for the values

Size the undesired columns so small that they kinda sorta disapperar.

Note: This is not dynamic. New column values will bleed through.

[Gabe_V · Accepted solution]

Thank you @lbendlin, I'll use that as a stop-gap. I think because this isn't dynamic as a backup I'll need help with my DAX to at least make those columns show correct data, on the off chance that I have to revert back to showing them.