Forum Discussion

jmerunka's avatar
jmerunka
Frequent Visitor
8 years ago

Error: Can't determine relationships between the fields

Hello all, I have been given a task to create a report based on our company source data in Power BI Unfortunatately my company has an absence of proper DWH and BI software and reports are therefo...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

jmerunka,

In your visual, I don't see any error message, could you please post expected result in  table format? And is there any possibility that you can share the PBIX file for me the check? 

Regards,
Lydia

jmerunka's avatar
jmerunka
Frequent Visitor
8 years ago

Visual in my previous post was OK, because the link via Status calc was removed:
a diagram with a removed link

When link is activated again:
a diagram with an activated link

it breaks for opportunities:

status_calc for opp
status_calc for sales

where Actual = status 1 and Backlog = status 2, Pipeline = status 3 and Unknown = status 4

A chart for Opportunities should not be empty and should be combined with sales in a stacked bar chart.

I am not sure if I can post any real tabular data here. I am still in a trial period. :)







 

  • jmerunka's avatar
    jmerunka
    Frequent Visitor
    8 years ago

    When I link Dim.Status_calc with :

    1) opportunity - it works
    2) sales - it works
    3) opportunity & sales - it does not work

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      jmerunka,

      It is difficult for us to provide you suggestions without PBIX file. You can make a PBIX file with dummy data, and send me the PBIX file via Private Message.

      Regards,
      Lydia