Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I am kind of stuck and I am quite new to PowerBI so any help will be much appreciated . Hopefully I can make sense with what I ask . I am currently trying to create a new data table based on this table visual attached below . The columns added are all from different tables that have a relationship with eachother. Is there anyway to create this as a data table ? I have tried to do this with the merge query function though I did have no luck. Any help will be much appreciated. Please any help would be greatly appreciated !!
Cheers!!
Creating
Hi @Anonymous ,
Just wanted to check on why the requireemnt is to create a new data table rather making use of relationships in Power BI and visualise the data in a table visual?
Also, you will need to add more details here. I can't understand much from the screenshot that you have shared.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks,
Pragati
Thanks for the reply @Pragati11 , that was initially my first thought is to create a measure, to calculate if a company is healthy or not. The aim for me is to create a measure which calculates the health of a compnay . This is decided if reports are turned on , notifications turned on and there is 2 or more users in a company , that company will be considered as 'healthy', sorry if that is confusing , this is also the best screenshot I can give I have to strike out company information , apologies
Hi @Anonymous
You might consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |