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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.