Forum Discussion

EricKautz's avatar
EricKautz
Helper I
2 years ago
Solved

How To Combine Calculated Measures into a Matrix Table Card

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.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

3 Replies

  • DataInsights's avatar
    DataInsights
    Super User
    2 years ago

    EricKautz,

     

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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.