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]))

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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