Forum Discussion
Inactive relationships with date table
Figured it out myself, they are calculation groups, sorry about that, had never used them myself and they are completely superfluous here 🙂 but at least it is clear now, speedramps thnx 4 ur time!
It's vague because so is my issue 🙂 sorry. I will try to clarify. There is a table:
| ID | Date1 | Date2 | Count |
| 1 | 01-01-2022 | 28-01-2022 | 3 |
| 2 | 15-01-2022 | 05-02-2022 | 5 |
| 3 | 06-02-2022 | 14-02-2022 | 4 |
Then ur common date table with 2 (actually 3 but that does not matter here) inactive relationships on the date, not going to repeat that here.
Then a third table (conspicuously named "TimeIntelligence..."), unrelated to the other two, with:
| TimeCalc | Ordinal |
| A (just a name for one of the inactive relationships) | 1 |
| B | 2 |
| C | 3 |
The measure is a total of the Count, nothing more. Normally you would use measures with USERELATIONSHIP to choose between the 2, but this is not the case in this PBIX. They put the third table in the FILTER of the visuals and choose which relationship to activate. When u pick relationship A in the FILTER pane it performs a calculation asif USERELATIONSHIP(A, Fact) was used, etc.
It works, and that is my question, why??? It does not make any sense. It is as if the ordinal value is somehow referencing the inactive relationship, but how?
Please can you save the PBIX with share access in PneDrive or DropBox and post the link here.
Sorry but I wont spend lots of time creating the PBIX for you but I will take a look at the PBIX if you can recreate the problems with non private data,
Here is an example of how to add a pbox to OneDrive
https://1drv.ms/u/s!AgMTUY3Uvq3bg7IbYncAD9xRkf4Rug?e=KMv7C1