Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hello there,
I have data set with 5 columns as per the image below:
Using this data set I create a quick matrix visual that gives me a breakdown of visits per year for each data source:
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
Solved! Go to Solution.
@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.
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.