How To Combine Calculated Measures into a Matrix Table Card

[EricKautz]

Hello,

I am trying to create a matrix table card with different types of assets and the total counts of each. The issue is, in my data set, I need to create measures for each doing countifs(countrows). If I create just a matrix table that has my rows the asset names and the count as my values (without filters) I get this nice table. 

I want to create this same look, but with the actual measures I create for each asset class. Any assistance is appreciated.

[DataInsights · Accepted solution]

@EricKautz,

Add all your measures to the Values field well and enable "Switch values to rows" in Format pane:

[Greg_Deckler · Accepted solution]

@EricKautz Perhaps try Values on rows?

[3CloudThomas · Accepted solution]

The image above shows the column name as 'Count of App ID'. If you have a measure created already, remove this column ('Count of App ID) and add the measure you created. AAlso, you can turn off the Auto Count/Sum/etc. on columns where you do not get this effect.

[Greg_Deckler · Accepted solution]

@EricKautz Perhaps try Values on rows?

[DataInsights · Accepted solution]

@EricKautz,

Add all your measures to the Values field well and enable "Switch values to rows" in Format pane: