Can you hide some columns of a matrix?

[Anonymous]

I am new to Power BI. I have created a simple matrix that looks like this:

Location	Active	Active	Non-Active	Non-Active	Total	Total
Name	Count	% Total	Count	% Total	Count	% Total
California	66	46%	76	54%	142	100%
Virginia	98	81%	23	19%	121	100%
Maryland	76	44%	98	56%	174	100%
Oregon	34	50%	34	50%	68	100%
Nebraska	97	75%	32	25%	129	100%
Nevada	12	12%	88	88%	100	100%
Total	383	52%	351	48%	734	100%

I received a request to hide some of the columns so that the resulting matrix will look something like this:

Location	Active	Total
Name	% Total	Count
California	46%	142
Virginia	81%	121
Maryland	44%	174
Oregon	50%	68
Nebraska	75%	129
Nevada	12%	100
Total	52%	734

How can this be accomplished? Thank you.

[Anonymous]

Hi @Anonymous ,

You gave go thru this post, similar is already solved.

https://community.powerbi.com/t5/Desktop/Hide-un-hide-un-wanted-Column-in-Matrix-Visualization/td-p/182015

May be it is helpful.

Thanks,

Tejaswi

[Anonymous]

I looked at it. It is not exactly what I need. How would I display Active % Total as a percentage and Total Count as a count? 

[v-chuncz-msft · Accepted solution]

@Anonymous 

Remove field from Columns and add measures below to Values.

Measure =
DIVIDE (
    COUNTROWS ( FILTER ( 'Table', 'Table'[Status] = "Active" ) ),
    COUNTROWS ( 'Table' )
)

Measure 2 =
COUNTROWS ( 'Table' )