Forum Discussion

SPH76's avatar
SPH76
New Member
3 years ago
Solved

Inactive relationships with date table

I have a really puzzling issue. Working with a PBIX file from third party. It seems they were unaware of how to use USERELATIONSHIP but somehow came up with alternative.    There is a Fact with 3 I...
Need Help
  • SPH76's avatar
    SPH76
    3 years ago

    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!

speedramps's avatar
speedramps
Super User
3 years ago

We want to help you but your description is too vaugue. Please write it again clearly.

Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
Also provide the example desired output, with a clear description of the process flow.

Remember not to share private data ... we don't want you to get into trouble. 😧

Take care to use the same table and field names in the input, output and description so we can understand your problem and help you.

You will get a quick response if you put time and effort into writing clear problem descriptions.

Vaugue descriptions can waste your time and ourtime.

Look foward to helping you when the above information is forthcoming

  • SPH76's avatar
    SPH76
    New Member
    3 years ago

    It's vague because so is my issue 🙂 sorry. I will try to clarify. There is a table:

     

    IDDate1Date2Count
    101-01-202228-01-20223
    215-01-202205-02-20225
    306-02-202214-02-20224

     

    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:

    TimeCalcOrdinal
    A (just a name for one of the inactive relationships)1
    B2
    C3

     

    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? 

    • speedramps's avatar
      speedramps
      Super User
      3 years ago

      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