Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi Dear,
As picture, I want both POD and POL of "StatistcLd" to have active relationship with "PortName" at the same time.
Column looks like this:
It doesnt reconize port code from Panama because its not active
Any way to do it except by merging 2 tables?
TIA
@javieezy like @DOLEARY85 said you can not have two relationship active at the same time. A workaround is to utitlize USERELATIONSHIP dax to make them active at the time of calculation.
Hi,
You cant have them active in the model at the same time but any measures you create you can use ACTIVERELATIONSHIP within DAX to activte them both at the same time for that calculations/column
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thx! How to use calculation if i want to view it as matrix?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
121 | |
112 | |
59 | |
58 |