DAX level of detail calculation

[vseeruthun]

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,

[vseeruthun]

How do I attach a .pbix file?

[aj1973]

Online services, like Onedrive Dropbox Google drive..the share the link

[aj1973]

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. 

[vseeruthun]

Hi Amine,

Please see link to the file I have mocked up

https://drive.google.com/file/d/1PKdNorBqL5FKu7KVEdxsdLeifxyjCDZW/view?usp=sharing

Thanks

[aj1973 · 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

[vseeruthun]

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

[aj1973]

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.

[Ashish_Mathur]

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.