Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
i have 2 Fact Tables "Sale" and "Cto", one "Sale" can be related with many "Cto" and one "Cto" can be related with many "Sale", they are related by the Key "Doc_ID". I made a bridge table "Bridge_Doc", now i want to obtain wich "CTO is not in a "Sale", using a filter or a measure, can you help me?
Thanks
Regards.
Solved! Go to Solution.
Hi,
Here's what i did. In the CTO Table, i wrote this calculated column formula
Hi,
Here's what i did. In the CTO Table, i wrote this calculated column formula
You are welcome.
Hi @carloscabreraq,
To get the solution quickly, please share some data sample which could reproduce your scenario and your desired output.
Best Regards,
Cherry
Hello @carloscabreraq
are you able to show a sample of your Data?
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |