Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix Drill up text filter

Hi everyone, I am working with a matrix that goes from account -> account group (think fast food would have burger king, mcdonalds, wendy's, but it would just be labeled fast food) -> account manager...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    4 years ago

    Hi Anonymous ,

     

    Based on your description, I have created a simple sample:

    Please try:

    Measure = IF(ISINSCOPE('Table'[Account Group]),MAX('Table (2)'[URL]),BLANK())

    Final output:

    Best Regards,

    Jianbo Li

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

     

     

     

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Based on your description, I have created a simple sample:

Please try:

Measure = IF(ISINSCOPE('Table'[Account Group]),MAX('Table (2)'[URL]),BLANK())

Final output:

Best Regards,

Jianbo Li

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

 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you wonderful person! It is working at the Account Group level, and it is working up, but unfortunately it is not showing at the account level. Do you have any suggestions?