Forum Discussion

wangjuan303's avatar
wangjuan303
Icon for Helper III rankHelper III
4 years ago
Solved

How to show report drill through value?

Hi Everyone, I have a drill through page, I can show drill through value one the top , it will looks like this,  but when my matric this column have multiple values, this Drill through value w...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi wangjuan303 ,

     

    As far as I know VALUES function will return a table based on your selection. However measure will return a single aggregate value. So when you only select one value you will get result and you couldn't get result when you get multiple values, even get error.

    Here I suggest you to try CONCATENATEX function to combine all values return by VALUES function.

    M_SAG =
IF (
    ISFILTERED ( 'Table'[sag] ),
    "SAG : " & CONCATENATEX ( VALUES ( 'Table'[sag] ), [sag], "/" ),
    BLANK ()
)

     

    Best Regards,
    Rico Zhou

     

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

     

wangjuan303's avatar
wangjuan303
Icon for Helper III rankHelper III
4 years ago

Test it, selectedvalue or Max all show blank too, Thank you 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi wangjuan303 ,

 

As far as I know VALUES function will return a table based on your selection. However measure will return a single aggregate value. So when you only select one value you will get result and you couldn't get result when you get multiple values, even get error.

Here I suggest you to try CONCATENATEX function to combine all values return by VALUES function.

M_SAG =
IF (
    ISFILTERED ( 'Table'[sag] ),
    "SAG : " & CONCATENATEX ( VALUES ( 'Table'[sag] ), [sag], "/" ),
    BLANK ()
)

 

Best Regards,
Rico Zhou

 

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