Forum Discussion

Icon for Resolver II rank

Resolver II

4 years ago

Solved

Custom calc in matrix total

Hi all - is there any way to get a custom calc in the the total row of a matrix visual? I need this visual to include the people in the list who don't have any values. For example, the 77.17% u...

v-easonf-msft
4 years ago
Hi, ctedesco3307

Have you tried the solution provided by PaulDBrown to change the total value?

You can refer to these silmilar threads.

Matrix-total-subtotal-row-customization

Totals and Subtotals in Matrix

For some reason I can't download your sample. If the problem isn't solved, please share your sample data and expected result in Excel for further research.

Best Regards,
Community Support Team _ Eason

Icon for Community Champion rank

Community Champion

4 years ago

To show a different result for the totals you can use the function ISINSCOPE.

So it would be something along the lines of:

Different total = IF(ISINSCOPE(Table[column]), [measure 1], [measure 2])

ctedesco3307
Resolver II
4 years ago
PaulDBrown Thank you for your reply. I will try this
- Greg_Deckler
  Community Champion
  4 years ago
  ctedesco3307 This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
  
  Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
  https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
  
  Also, MM3TR&R may help: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community