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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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