Reply
Frequent Visitor
Posts: 4
Registered: ‎04-10-2018
Accepted Solution

Table Matrix Just Show Percentage of Grant Total Column

Hello,

 

I have a matrix table filled with values in normal number format.

 

I also have a totals column.

 

I am just looking to add a percentages of the totals next to the totals column. I do not want to see percentages for each column that exists. Just the totals column.

 

How can I add this one column addition onto my matrix table? 


Accepted Solutions
Highlighted
Advisor
Posts: 120
Registered: ‎11-10-2015

Re: Table Matrix Just Show Percentage of Grant Total Column

[ Edited ]

 

Hi mpichardo, 

 

Do you mean someting like this?

 

Capture.PNG

 

 

 

 

 

 

 

 

 

I could not find an "official" way to hide the % column for each year. What is did is just make the column smaller. 

Also I changed the formula, to exclude values for the year level. 

 

% of total =
IF (
    ISFILTERED ( 'Date'[CalendarYear] );
    BLANK ();
    DIVIDE (
        [Sum of SalesAmount];
        CALCULATE ( [Sum of SalesAmount]; ALL ( FactOnlineSales ) )
    )
)

 

Hope this helps. 

 

 

Cheers, Edgar Walther
Power BI User Group Netherlands

View solution in original post


All Replies
Highlighted
Advisor
Posts: 120
Registered: ‎11-10-2015

Re: Table Matrix Just Show Percentage of Grant Total Column

[ Edited ]

 

Hi mpichardo, 

 

Do you mean someting like this?

 

Capture.PNG

 

 

 

 

 

 

 

 

 

I could not find an "official" way to hide the % column for each year. What is did is just make the column smaller. 

Also I changed the formula, to exclude values for the year level. 

 

% of total =
IF (
    ISFILTERED ( 'Date'[CalendarYear] );
    BLANK ();
    DIVIDE (
        [Sum of SalesAmount];
        CALCULATE ( [Sum of SalesAmount]; ALL ( FactOnlineSales ) )
    )
)

 

Hope this helps. 

 

 

Cheers, Edgar Walther
Power BI User Group Netherlands
Frequent Visitor
Posts: 4
Registered: ‎04-10-2018

Re: Table Matrix Just Show Percentage of Grant Total Column

Yes just like that, by the way, your code where did you write that? Into Calculated Column? I am trying to duplicate your formula for my table

Member
Posts: 105
Registered: ‎09-14-2017

Re: Table Matrix Just Show Percentage of Grant Total Column

You need to create a measure

Frequent Visitor
Posts: 4
Registered: ‎04-10-2018

Re: Table Matrix Just Show Percentage of Grant Total Column

Are you sure its a measure? Everytime I put in the semicolon I get an error I tried calculated column that didn't work either.

Member
Posts: 105
Registered: ‎09-14-2017

Re: Table Matrix Just Show Percentage of Grant Total Column

That is probably because the responder is from another country. I believe in Europe they use semicolons. Try to replace the semicolons with commas.

Advisor
Posts: 120
Registered: ‎11-10-2015

Re: Table Matrix Just Show Percentage of Grant Total Column

[ Edited ]

Yes @vega is right. It is a measure. and you may need to replace the ; with ,   Sorry about that. 

 

 

Cheers, Edgar Walther
Power BI User Group Netherlands