I am a complete Power BI newbie - unleashed upon my organisation with the barest minimum of training and I'm just "technie" enough to be dangerous.
I am tracking intranet pageviews. I want to calculate the percentage of particular page titles against the total number of pageviews. I have created "categories" for each of our content sections and the selected page titles fall under the MH section. Page titles rows are not unique in the table because they are tracked by fiscal/quarter:
For example:
- Can I create a visual that shows that selected pageviews totalling 37,660 is 34.6% of 108,660, the total number of pageviews for the whole intranet site (e.g. a pie)?
- Can I add a column in the above table visual example that shows that the Mental Health page is 14.6% of overall total pageviews for our intranet?
My heart tells me it can be done but my completely math-challenged brain says, "Have you met me?"
Thanks!
Ok, so, I think I've solved your first issue and gone part of the way to solving the second, but lets just start with the attached PBIX and go from there. I think it will be enough to help you along.
Points to note...
- Unless I copy and pasted wrong, the data you provided only totalled 82633 so the percentages don't match your desired result.
- I took the list of pages you want to isolate and merged (in Power Query [Transform Data]) with your dataset and added a custom column. This helps for filtering when writing the DAX measures.
- Created a Total Page Views measure that ignores all filters on the data table.
- Created a Page Views (filtered) measure, filtering to only include those in the custom column I created.
- Created a Filtered View % measure.
I hope this helps.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Wow, that's really old.
With the monthly release cycle of PBI, they really should install from the Microsoft Store (auto updating version) or at least let you update regularly.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Oh, right. 😶
I don't have a stone knife solution. Sorry. 🐻🔪
PBI isn't the sort of software that you can install and never upgrade. You will run into problem after problem if you can't at least operate on n - 1 e.g. the previous version.
Hopefully you can get it upgraded, I think I've solved most of the issues.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @Anonymous,
Should be easy enough. Can you paste some raw data (not a screen shot) for us to work with.
Mask anything that is sesitive obviously.
I'll move this over to the 'Desktop' section of the forum as this is not really Power Query specific.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
