Forum Discussion

blairc15's avatar
blairc15
Regular Visitor
3 years ago

DISTINCTCOUNT with multiple USERELATIONSHIPS

Hello,   I have two tables: 1) A table (Universe Table) listing all possible stores that we could sell a product into 2) A table (Depletion Data Table) listing all stores that product was actually ...
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , blairc15 

Based on your description, you want to automatically modify the relationship between two tables. Right?

Currently in Power BI, USERELATIONSHIP() can only be used in functions that take a filter as an argument.

And there is an activation relationship between the two tables, and if the USERELATIONSHIP() function is not used, the current filtering context is calculated in the activation relationship, we can use the USERELATIONSHIP() function in the measure to activate the inactive relationship, and only the measure is calculated according to the relationship, if we want to implement the calculation in multiple dimensions, we need to create multiple measures to achieve.

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • blairc15's avatar
    blairc15
    Regular Visitor
    3 years ago

    Hi Aniya, thank you for your response. It is not feasible to have different measures. Is there another way to achieve the same result without having to use "USERELATIONSHIPS"?