Reply
Spetkovic
New Member
Partially syndicated - Outbound

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

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)