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

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