Forum Discussion

Mister_T's avatar
Mister_T
Icon for Advocate I rankAdvocate I
5 years ago
Solved

Matrix visual: Show values of one column (value) only for specific rows

Dear Forum, I have defined in a Matrix visual Rows: "Continent" "Country" "Shop" Values: "Count_Subsidiaries" "URL_Shop" Now, I want to connect each Shop to its corresponding Web URL. ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Mister_T ,

     

    Based on your description, you can create a measure as follows.

    Measure = IF(HASONEVALUE('Sheet4'[Continent]),MAX('Sheet4'[URL_Shop]))

    Result:

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    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
    5 years ago

    Hi Mister_T ,

     

    Thanks for your reply. I modified the measure as follows.

    modified_Measure = IF(ISINSCOPE('test for url'[Continent]),MAX('test for url'[URL_Shop]))

    Result:

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    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
5 years ago

Hi Mister_T ,

 

Based on your description, you can create a measure as follows.

Measure = IF(HASONEVALUE('Sheet4'[Continent]),MAX('Sheet4'[URL_Shop]))

Result:

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

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

 

Mister_T's avatar
Mister_T
Icon for Advocate I rankAdvocate I
5 years ago

Hi Anonymous,

 

thank you very much for your support! Sorry for my late reaction. I unfortunately was not available for some time.

I have tested your solution, but unfortunately it only works in case there is more than one shop per country. In case there is only one shop listed in a specific country, then I still have an URL on country level. I would like to have the URL at the store level only, regardless of the number of stores per country. Any idea how to fix this?

Thanks a lot!

Best regards,

Mister_T

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Mister_T ,

     

    Thanks for your reply. I modified the measure as follows.

    modified_Measure = IF(ISINSCOPE('test for url'[Continent]),MAX('test for url'[URL_Shop]))

    Result:

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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

    • Mister_T's avatar
      Mister_T
      Icon for Advocate I rankAdvocate I
      5 years ago

      Hi Anonymous,

      It works like a charm! Exactly, what I was looking for. Thank you very much!

      Have a great day!

      Mister_T