Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I'm new to PowerBI, but havce been using Tableau extensively previously.
Can someone help me with the calculation between two different tables, I've tried previously but seem to be getting a different level of detail.
I have two tables: Applications and Quotes that are independant from one another. I would then like to divide Apps/Quotes to get a conversion %. I used a quick measure calculation, but this just returns me zero for all.
Can someone help please?
Thanks,
Solved! Go to Solution.
Hi @vseeruthun
Here you go,
https://drive.google.com/file/d/15X-xg41VipnRR9D06Lu-XUM2BJhr5_9U/view?usp=sharing
I added an Area table to your model and corrected the Unique Quotes measure
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
How do I attach a .pbix file?
Online services, like Onedrive Dropbox Google drive..the share the link
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @vseeruthun
Can you provide a sample of your file? It's not clear how your tables are conneted and what are those measures you added.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi Amine,
Please see link to the file I have mocked up
https://drive.google.com/file/d/1PKdNorBqL5FKu7KVEdxsdLeifxyjCDZW/view?usp=sharing
Thanks
Hi @vseeruthun
Here you go,
https://drive.google.com/file/d/15X-xg41VipnRR9D06Lu-XUM2BJhr5_9U/view?usp=sharing
I added an Area table to your model and corrected the Unique Quotes measure
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi Amine,
Thank you for doing this, are you able to upload back to my Gdrive?
My company is preventing me from downloading the file so i'm unable to see the file.
Best Regards,
Vinay S
Vinay, Of course I am not able to upload anything to your drive, it's personel and private.
Find a way to download my file outside your company's network.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi,
Make the following corrections/amendments:
Hope this helps.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
59 | |
58 |