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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |