Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mpichardo
New Member

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? 

1 ACCEPTED SOLUTION
waltheed
Solution Supplier
Solution Supplier

 

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
ITsmart BI and Analytics consultant

View solution in original post

9 REPLIES 9
mpichardo
New Member

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

You need to create a measure

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.

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

waltheed
Solution Supplier
Solution Supplier

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

 

 

Cheers, Edgar Walther
ITsmart BI and Analytics consultant
waltheed
Solution Supplier
Solution Supplier

 

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
ITsmart BI and Analytics consultant
Anonymous
Not applicable

How did you exclude the Value header and column subtotals for "% of total"?

I could not find an "official" way to hide the % column for each year. What is did is just make the column so small that you don't see it.  

 

 

Cheers, Edgar Walther
ITsmart BI and Analytics consultant
Anonymous
Not applicable

Oops, I forgot I had word-wrap on.  Thanks for the quick response though!

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.