Forum Discussion

klintala's avatar
klintala
Frequent Visitor
5 years ago

USERELATIONSHIP to filter new visual

I have a matrix built out based on the red relationship (comprised mostly of information from the left tabel). I would like to create a another matrix, this one containing all the columns in the left table. I want this matrix to be filter to show all "Development" based on the item selected in the original matrix. I have found no combination of CALCULATE, USERELATIONSHIP, ALL and ALLEXCEPT to get the disered resutls to return.
Intuitevly, I thought the line below would work. I would load the columns form the left table into a matrix and add this measure:
 = CALCULATE(MAX(LeftTable[Actual_date]),USERELATIONSHIP(LeftTable[Development],RightTable[Development]),ALLEXCEPT(RightTable,RightTable[Development]))

Need Help

2 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago

    klintala Many to Many relationships are complex, as is both cross filter direction. Are you able to provide more context for your data (sample data if possible) and why there is a many to many relationship. Because of this, we need to know exactly what result you are expecting, as there won't be simply one choice for the meausre result. How do you want the results aggregated? 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi klintala ，

     

    Would you please inform us more detailed information( your

     data and expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.

     

    Please do mask sensitive data before uploading.

     

    Thanks for your understanding and support.

     

    Best Regards,

    Dedmon Dai