Adding a Total Column to a Matrix Visual that only sums spcific columns

Question

I have a table that has (simplified) the columns CustID, Action, Date

I then have a matrix visual that has Action as Columns, CustID AS Rows and Count(Action) as Values.

Now I need an extra column that sums only some of the Columns, not all like the Total. In Excel this is =SUMME(B11:K11), where K12 and K13 are the columns not to be summed.

Is this possible in PBI Matrix?

pattemmanohar · Answer

Anonymous&nbsp;Please post the sample data (copiable format) and expected output to understand your scenario in detail. It will be helpful to provide an accurate solution.

anonymous · Answer

how do I do that in copiable format?

pattemmanohar · Answer

Anonymous&nbsp;I mean the sample data that can be copied. Not like screenshots or image format.

anonymous · Answer

This is the simplified data structure:&nbsp;This is the table:DateCustIdAction01.01.20181A02.01.20181B03.01.20181A04.01.20181C05.01.20182A06.01.20182A07.01.20182C08.01.20182C09.01.20182C10.01.20182D&nbsp;Expected outcome (I did this as a Matrix in PBI, but cannot see a way to add the Sum(A,B) column):&nbsp;PIVOT Values are Count(Action)&nbsp;&nbsp;&nbsp;&nbsp;Action&nbsp;&nbsp;&nbsp;&nbsp;CustIdABCDSum (A,B)121103223015&nbsp;&nbsp;

v-yuta-msft · Answer

Hi&nbsp;DevOn99,
&nbsp;
You you create measures using DAX formula like pattern below:
A = CALCULATE(COUNT(Table1[Action]), FILTER(ALLEXCEPT(Table1, Table1[CustId]), Table1[Action] = "A"))

B = CALCULATE(COUNT(Table1[Action]), FILTER(ALLEXCEPT(Table1, Table1[CustId]), Table1[Action] = "B"))

C = CALCULATE(COUNT(Table1[Action]), FILTER(ALLEXCEPT(Table1, Table1[CustId]), Table1[Action] = "C"))

D = CALCULATE(COUNT(Table1[Action]), FILTER(ALLEXCEPT(Table1, Table1[CustId]), Table1[Action] = "D"))

Sum(A, B) = CALCULATE(COUNT(Table1[Action]), FILTER(ALLEXCEPT(Table1, Table1[CustId]), Table1[Action] = "A" || Table1[Action] = "B"))

This result is like this:
&nbsp;
&nbsp;
Regards,
Jimmy Tao

Forum Discussion

Adding a Total Column to a Matrix Visual that only sums spcific columns

10 Replies

Related content

Adding columns

Adding a column

Renaming columns and adding columns

Adding filters to a calculated column

How to show data in columns as xxxxx for particular ad groups?