Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
vseeruthun
Frequent Visitor

DAX level of detail calculation

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,

 

MockReport.PNG

1 ACCEPTED 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

aj1973_0-1632145809088.pngaj1973_1-1632145876182.png

 

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

View solution in original post

8 REPLIES 8
vseeruthun
Frequent Visitor

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

aj1973
Community Champion
Community Champion

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

aj1973_0-1632145809088.pngaj1973_1-1632145876182.png

 

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:

  1. Create 2 more tables - one for week and another for Area.  Each of these tables should only have unique entries.
  2. Create a relationship (Many to One and Single) from the Applications and Quotes tables to the tables created in step 1 above
  3. To each visual, drag Week and Area from the tables created in step 1 above
  4. Simplify your unique quotes measure to = DISTINCTCOUNT(Quotes[Customer Ref])

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.