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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Spetkovic
New Member

How to calculate Sum of total in matrix?

Hello there, 
I have data set with 5 columns as per the image below:

Spetkovic_0-1660032931947.png

 

Using this data set I create a quick matrix visual that gives me a breakdown of visits per year for each data source:

Spetkovic_1-1660033004993.png

 

What I also need to do is to create another matrix with the same breakdown but instead of the sum of visits I need  % of the total.

So for example, for Data Source A for 2022, we have 37,178 visits. The total number of visits for that particular month across all sources is 347,473. So, my percent of the total should be 37,178 / 347,473 = 10,7%

 

How do I make this matrix show the percent of the total for the particular time period?

 

Here is my powerbi file:
https://1drv.ms/u/s!AhhZq1add5YwjoZ9GvYPwUCdNhTxBQ?e=ZQbfwF

 

 

1 ACCEPTED SOLUTION
ddpl
Solution Sage
Solution Sage

@Spetkovic  try this,

 

ddpl_0-1660020432786.png

 Please accept as solution if its worked.

View solution in original post

3 REPLIES 3
ddpl
Solution Sage
Solution Sage

@Spetkovic Its easy and efficient, you can go throgh available Dax Basic you tube videos of goodly and pavan lalwani's you tube channel.

 

If my previous reply works for you then please accept it as a solution so others can easily find.

Spetkovic
New Member

This solution...just made me humble as a human. 
It is embarrassing how much I don't know 😞

I was trying all kinds of complexity with measures and even creating a new table...

Thank you so much. 

ddpl
Solution Sage
Solution Sage

@Spetkovic  try this,

 

ddpl_0-1660020432786.png

 Please accept as solution if its worked.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.