Forum Discussion

mrbrewmaster's avatar
mrbrewmaster
Regular Visitor
6 years ago
Solved

Relationship status impacting data visualization?

I apologize in advance; I am still very new to Power BI and the whole Power Platform.   I am using a custom order entity in Power Apps (CDS) to track order requests from customers. This order entit...
Need Help
  • mrbrewmaster's avatar
    mrbrewmaster
    6 years ago

    As I suspected the solution came down to my improper use of the Relations between entities. I spent some more time familiarizing myself with DAX. Specifically the USERELATIONSHIP function and managed to bypass the troublesome active relationship and specify a sales volume with a brand. 

     

    Sorry for the confusing nature of my previous replies. I am still very new to this. I appreciate all the attempts to help clarify.

     

     

    Total Volume (Filtered) = CALCULATE(SUM(volume1]), USERELATIONSHIP(brandid],brand1]))
    + CALCULATE(SUM(volume2]), USERELATIONSHIP(brandid],brand2]))
    + CALCULATE(SUM(volume3]), USERELATIONSHIP(brandid],brand3]))
    + CALCULATE(SUM(volume4]), USERELATIONSHIP(brandid],brand4]))

     

     

mrbrewmaster's avatar
mrbrewmaster
Regular Visitor
6 years ago

To clarify, the data table in Power BI looks like this

 

Cust.

Brand 1

Brand 2

Brand 3

Brand 4

Brand 1 Size

Brand 2 Size

Brand 3 Size

Brand 4 Size

Brand 1 Count

Brand 2 Count

Brand 3 Count

Brand 4 Count

Customer A ID

A

B

C

A

A

A

B

B

10

2

10

10

 

Customer B ID

D

A

B

null

A

A

B

null

5

10

5

null

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    mrbrewmaster , is your data is in the format you have mentioned in the first post and you want data like your second post ??

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

     

    • mrbrewmaster's avatar
      mrbrewmaster
      Regular Visitor
      6 years ago

      amitchandakMy data looks like in my second post. Here is a table grab from my test.

       

      distributionidsize1countsize1volumesize2countsize2volumesize3countsize3volumesize4countsize4volumeinvoice_namepickupdatetimedistribution_accountbrand1brand2brand3brand4size1size2size3size4
      bd79c36c-66b5-ea11-a812-000d3a8a493410.520.322121TEST-06-23-20-10006/26/2020 17:00c8f7cfe0-65b5-ea11-a812-000d3a8a4934e0faa3ac-f299-ea11-a811-000d3a8a4934e0faa3ac-f299-ea11-a811-000d3a8a4934ada2a2e8-09a1-ea11-a812-000d3a8a493457e48445-85b2-ea11-a812-000d3a8a4934e7d7c02a-0fa1-ea11-a812-000d3a8a49349d35d35b-0fa1-ea11-a812-000d3a8a4934e7d7c02a-0fa1-ea11-a812-000d3a8a4934e7d7c02a-0fa1-ea11-a812-000d3a8a4934
      fb63c6ef-c3b5-ea11-a812-000d3a8a493410.510.5    TEST-06-24-20-10047/10/2020 15:00fc78dc14-2e9a-ea11-a811-000d3a8a49344258c728-f399-ea11-a811-000d3a8a4934ee10d0d0-88b2-ea11-a812-000d3a8a4934  e7d7c02a-0fa1-ea11-a812-000d3a8a4934e7d7c02a-0fa1-ea11-a812-000d3a8a4934  
      e1372cc3-c3b5-ea11-a812-000d3a8a493431.521    TEST-06-24-20-10038/3/2020 15:00fc78dc14-2e9a-ea11-a811-000d3a8a493453cda586-9768-ea11-a811-000d3a8a49341838cc6e-f099-ea11-a811-000d3a8a4934  e7d7c02a-0fa1-ea11-a812-000d3a8a4934e7d7c02a-0fa1-ea11-a812-000d3a8a4934  
      11620893-c3b5-ea11-a812-000d3a8a493410.16      TEST-06-24-20-10028/5/2020 17:00c8f7cfe0-65b5-ea11-a812-000d3a8a49344258c728-f399-ea11-a811-000d3a8a4934   9d35d35b-0fa1-ea11-a812-000d3a8a4934   
      16dc4bc9-c2b5-ea11-a812-000d3a8a493410550.82181.28TEST-06-24-20-10017/1/2020 17:00c8f7cfe0-65b5-ea11-a812-000d3a8a493464c19bbc-f299-ea11-a811-000d3a8a4934ee10d0d0-88b2-ea11-a812-000d3a8a4934ada2a2e8-09a1-ea11-a812-000d3a8a49347b55a5fd-09a1-ea11-a812-000d3a8a4934e7d7c02a-0fa1-ea11-a812-000d3a8a49349d35d35b-0fa1-ea11-a812-000d3a8a4934e7d7c02a-0fa1-ea11-a812-000d3a8a49349d35d35b-0fa1-ea11-a812-000d3a8a4934