Forum Discussion

alee5210's avatar
alee5210
Icon for Helper II rankHelper II
2 years ago
Solved

Matrix Rollup When Using Text

Hi, I am having some issues with the matrix visual when I want text to roll up. Right now I have some data that looks like the below. It is simple with the main city, the store, how the store is perf...
Need Help
Show and Tell
Tips and Tricks
  • alee5210's avatar
    alee5210
    2 years ago

    I have found a solution using the measure below:

     

    Test Measure =
    if(
       count('Test Data'[Comment])=1, -- Count the number of comments and if it is equal to 1
       selectedvalue('Test Data'[Comment]), --Then use the comment that is 'provided'
       calculate(selectedvalue('Test Data'[Comment]), 'Test Data'[Comment Number] = max('Test Data'[Comment Number]))) -- If there is more than one comment then select the comment where the comment number is equal to max(comment number)
     
    This seems to give me the result I am looking for in this case.

     

    It does not solve the first case though when you expand it, once expanded the top level is blank which is something I will live with.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Read about ISINSCOPE and then decide how you want to handle each of the scenarios.

alee5210's avatar
alee5210
Icon for Helper II rankHelper II
2 years ago

I have had a look at ISINSCOPE but i'm not sure if it is applicable to this scenario. It looks like it can filter data but not roll up data when using the matrix visual. Can you give me a bit more direction as to how to apply it?