Forum Discussion

alexa_0028's avatar
alexa_0028
Icon for Resolver II rankResolver II
5 years ago
Solved

Relationship between tables showing incorrect data in PowerBI

Hi All, I am new to power bi and I am not able to understand why my table is showing incorrect behavior. I have 3 tables with relationships defined as the diagram below. When I create the ...
Need Help
  • alexa_0028's avatar
    alexa_0028
    5 years ago

    Anonymous  thanks for your help !!
    I really appreciate it, I tried to changed my relationships and it seemed to work.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi alexa_0028 ,

I updated your sample pbix file with the below steps, please check whether that is what you want. You can find the attachment for the details.

1. Change the data type of field sales of Fact table as Whole number

2. Create a measure as below to get the details of per item

 

NDetails = 
CONCATENATEX (
    FILTER (
        'Dimension2',
        'Dimension2'[key1] = SELECTEDVALUE ( 'Dimension1'[key1] )
    ),
    'Dimension2'[details],
    ", ",
    'Dimension2'[details], ASC
)

 

Best Regards

alexa_0028's avatar
alexa_0028
Icon for Resolver II rankResolver II
5 years ago

Anonymous  thanks for your help !!
I really appreciate it, I tried to changed my relationships and it seemed to work.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi alexa_0028 ,

    It's glad to hear that your problem has been resolved. Could you please mark the helpful post as Answered since it work now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

    Best Regards