cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors