Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone, I have a model with multiple fact tables related via the Customer dimension and a hidden bridging table (UUID). The model schema is below:
Digital Campaigns fact table stores campaign activity: impressions and clicks. It is related to customers via SBLID. It also has a campaign list related to it as a dimension.
Digital Events fact table has logins, orders and payments. It is related to customers via UUID.
I need to create measures calculating digital events by each campaign, e.g. how many orders each campaign fetched.
The expected outcome is below, the sample file is attached here.
Thank you!
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please check the below measures and the attached pbix file.
This works, thank you very much!
Hi,
I am not sure if I understood your question correctly, but please check the below measures and the attached pbix file.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |