cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

Thanks,

1 ACCEPTED SOLUTION
Community Champion

Here you go,

I added an Area table to your model and corrected the Unique Quotes measure

Regards
Amine Jerbi

and you can follow me on

8 REPLIES 8
Frequent Visitor

How do I attach a .pbix file?

Community Champion

Regards
Amine Jerbi

and you can follow me on

Community Champion

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

and you can follow me on

Frequent Visitor

Hi Amine,

Thanks

Community Champion

Here you go,

I added an Area table to your model and corrected the Unique Quotes measure

Regards
Amine Jerbi

and you can follow me on

Frequent Visitor

Hi Amine,

Thank you for doing this, are you able to upload back to my Gdrive?

Best Regards,

Vinay S

Community Champion

Vinay, Of course I am not able to upload anything to your drive, it's personel and private.

Regards
Amine Jerbi

and you can follow me on

Super User

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors