Custom column total in Power BI matrix

Question

so Below is the snapshot of my power Bi Desktop&nbsp;&nbsp;I have created three Parameteric field from where we can select threshold value&nbsp;&nbsp;i have created measure using case when statement&nbsp;&nbsp; &nbsp; CE Category = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VAR CE_var = qa_branch_score[CE]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;SWITCH(TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CE_var &lt; 'Very High'[Parameter Value], 3,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CE_var &lt; 'H'[H Value], 2,&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CE_var &lt; 'MEDIUM THRESHOLD VALUE'[M Value], 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; )&nbsp;based on input i am assigning 3 , 2 , 1 and 0 value . This is working fine.&nbsp;Now Problem is that is Total column I want to add Ce category for all three month&nbsp;&nbsp;&nbsp;so for exampe&nbsp; March score 3 , april 2 and may score 1 and june score is&nbsp; 0 , so in total I want 6 ( i.e. 3+2+1+0 ) do let me know if any further input is required from my end.&nbsp;&nbsp;

anonymous · Answer

Hi.See related question:https://community.fabric.microsoft.com/t5/Desktop/Matrix-custom-Column-Total/m-p/2341055#M844501and the answer provided by users&nbsp;amitchandak&nbsp;linking to resources that describes ways to customize the information in a Matrix:https://community.fabric.microsoft.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591&nbsp;

Forum Discussion

Custom column total in Power BI matrix

1 Reply

Related content

Customize subtotal in matrix

Custom Matrix Visual

Matrix Column Widths

Matrix column based on other matrix columns

Matrix column not grouped